Line chart

[Anonymous]

Hi,

I need to create a line chart using below data. when I tried it is summing up all the values.

Is it possible to show three values for single date in a line chart? Please help.

if not please suggest good chart to show case.

Date	BOD	EOD
07/14/2021	9.3	9.5
07/14/2021	10.3	10.6
07/14/2021	9.7	9.8
07/15/2021	9.6	7.8
07/15/2021	10.5	11.3
07/15/2021	9.8	10.2

[community_pinki]

Hi @Anonymous ,
Yes,We can have a multiple lines in the Line chart.
I have tried you can check it out in attachment.
It is showing the values for BOD and EOD for a particular date when hover over on the markers without summing up in the tooltip of line chart.

[amitchandak · Accepted solution]

@Anonymous , And the random number to DateTime

Date time= [Date]+ Time(0,0,rand() )

Then try these new columns

[Anonymous]

Hi @amitchandak ,

Some how your formula is working, but two rows are showing same value and one row is showing another value. I need three rows should be different. Any help is highly appreciated.

Thanks,

Rajendra

[Anonymous]

@amitchandak , thank you.

But only problem with this formula, is I am getting x axis as more lines.

One date is dividing into three after adding random values.

is there any way we can show three values in one single date? I have around 6 measures and one date (dimension).

Please suggest.

Thanks,

Rajendra