3 Replies Latest reply: Jan 12, 2016 4:00 AM by Kumar Pramod RSS

    Line chart with a date_picker

    Kumar Pramod

      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_nameaction_countdatehour
      click211-01-20164
      sent510-01-20165
      delivered4
      10-01-2016
      6
      click710-01-20167
      click1810-01-20169

       

       

      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.