Smart multiline chart struggle

[Nils_Guicherd]

## Feature(s) impacted
Smart charts, sql queries, multiple line charts

## Observed behavior
I observed that in a simple query time chart I couldnt have multiple lines.
But when I send my query to postgre, I received two different data set that are not understood. See Img 1.

When I use the smart chart builder, I want to have a json formatted data set that I don’t know how to implement.
I used the fetchData() function but the link : /forest/… I can’t manage to get the data I want.

I also tried to use the documentation on this link : Create multiple line charts - Woodshop

But I could not manage to write the component section of the smart chart builder correctly.

What I could manage to do is a multiple line chart with a data set in json that I wrote but these are not the data I wanted.
I used the D3 library to visualize the chart through the builder (Template and Component).

## Expected behavior
I want to have a superposition of the users in a time chart. In order to make my dashboard more efficient.

## Failure Logs
I had this log when I tried to use the documentation above in the component section of the smart chart builder.

## Context

• Project name: ExplorJob
• Team name: Interface developpers
• Database type: postgre sql

Thanks for your help !

[Arnaud_Moncel]

Hi @Nils_Guicherd

I observed that in a simple query time chart I couldnt have multiple lines.

You’r right! It is not possible today.

The best and easiest way to do that is to use an API line chart.
You must create a route on your express app like below

And after that create the chart just like below

Let me know if that help

[Nils_Guicherd]

Thanks, so where do I create this api route ? What do you mean by express app ?

Then I have to send an sql query and transform the response into the json body you wrote right ?

[Arnaud_Moncel]

You must create this route inside your forest-express-sequelize agent code, on your server. (is what i mean by express app )

And instead of datas object on my screen you must get your datas you want form your database and format it this way.

[Nils_Guicherd]

great thanks for your support

[Arnaud_Moncel]

Is it working like you want now?
Can i close the topic?

[Nils_Guicherd]

i guess so, just waiting for some internal processes to make it work but it should be fine.
thanks,

[Nils_Guicherd]

I figured it out how to implement a new route for an API time based chart with the documentation but the request is obliged to be a POST ? Why not a GET ?

See here below my code :

The query functions as I tested it before in a query chart, but I get only one line.

This is what I get from the console

Have you any idea why I get this error ?