Hi, my data set looks like this...
Product, DateTime, Value
P1, 2023-02-01 12:00, 1
P1, 2023-02-01 13:00, 1.5
P1, 2023-02-01 14:00, 1.8
P1, 2023-02-01 15:00, 1.3
P1, 2023-02-01 16:00, 2
P2, 2023-02-01 13:00, 4
P2, 2023-02-01 14:00, 4.5
P2, 2023-02-01 15:00, 6
P2, 2023-02-01 16:00, 6.3
P2, 2023-02-01 17:00, 3
I want to create a line chart that shows P1, P2, P3 on the same chart but can't get it done properly. The chart seems a bit weird. I tested the same thing using SSRS and Excel, no problem to get it automatically populated. Some how Crystal Report a bit different behaviour.
Y axis = value
X axis = time
Anybody having success doing it ?