Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
| 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.
Hi,
It could be the date format mismatch.
Do you have an example of how you are setting your variable?
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.
I have years of data, instead of scrolling for the required date in list i can select it easily right