Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Line chart

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.

 

DateBODEOD
07/14/20219.39.5
07/14/202110.310.6
07/14/20219.79.8
07/15/20219.67.8
07/15/202110.511.3
07/15/20219.810.2
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , And the random number to DateTime

     

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

     

    Then try these new columns

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , And the random number to DateTime

     

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

     

    Then try these new columns

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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

  • community_pinki's avatar
    community_pinki
    Helper II
    4 years ago

    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.