Line chart with a date_picker

[#1]

Hi all,

I am trying to create a line chart where hour as dimension and action count as measure.

and i am filtering the data through particular date using date_picker and one filter pane action_name.

but when i select the date the data should show only to that particular date. it's not filtering according to the date.

Table structure:

action_name	action_count	date	hour
click	2	11-01-2016	4
sent	5	10-01-2016	5
delivered	4	10-01-2016	6
click	7	10-01-2016	7
click	18	10-01-2016	9

For example:

If i select a date 10-01-2016 in a date_picker  and action_name "click" in filter pane.

in x-axis the 0 to 23 hours should display and y-axis the the action_count for that particular hour.

I am using measure as: only({< action_date = {"$(=Date(vStartDate))"} >} action_count)

but not working help on this.

[#2]

Hi,

It could be the date format mismatch.

Do you have an example of how you are setting your variable?

[jonathandienst]

Why do you need to use a date picker and a variable? Simply expose the date field in a list and let the user select the date in the list.

[#4]

I have years of data, instead of scrolling for the required date in list i can select it easily right