I have a columns in my table as follows (with some sample data):
Date Hour Price
20/01/2014 18:00 5:00
20/01/2014 19:00 10:00
20/01/2014 20:00 15:00
22/01/2014 18:00 5.00
22/01/2014 19:00 20.00
22/01/2014 20:00 10.00
23/01/2014 18:00 8.00
23/01/2014 19:00 8.00
23/01/2014 20:00 8.00
....
I would like to plot a chart of all individual price (y axis) over hours (y-axis) for a certain date (say 22/01/2014). Please can you give some advise how this can be accomplished, presumably using SET analysis.
The easiest way is to use a listbox to simply select the date. That way you don't need set analysis at all. If you want to hardcode the date then you can use the expression only({<Date={'22/01/2014'}>} Price).
The easiest way is to use a listbox to simply select the date. That way you don't need set analysis at all. If you want to hardcode the date then you can use the expression only({<Date={'22/01/2014'}>} Price).
