How to create chart using SET analysis

[#1]

Hi,

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.

Thanks

Shaun

[Gysbert_Wassenaar · Accepted solution]

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

[#3]

Thanks, the only functions worked with the set analysis.