3 Replies Latest reply: Apr 2, 2018 3:00 AM by Krishna Kumar Balachandran RSS

    creating filters for last24 hours, last 7 days etc.,

    Krishna Kumar Balachandran

      We have our data in hour granularity. schema is like this

       

      power_consumed:

      LOAD

      area,

      power,

      time;

       

      SELECT

      area,

      power,

      [time]

      FROM utilisation;


      In our charts x- axis is time, y axis is say power and area. I want to create a chart where I can have a drop down or buttons like last24 hours, last 7 days etc., and on selection I should be seeing only 24 hours or 7 days or 30 days of data.