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...
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

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