8 Replies Latest reply: Jan 3, 2018 10:10 PM by pradosh thakur RSS

    Time Period Dimension for a Filter

    Jeffrey Catterson

      What is the best way to build a dynamic timeframe?  what I am looking to do is  build pre set time periods based on a month/year coming from the data set.  Ideally, I would like to build a 3 month/6 month 12 month time period.  Rather than a user see in a filter drop down:

       

       

      JAN 17

      FEB 17

      MAR 17

      APR 17

      MAY 17

      JUN 17

      JUL 17

      AUG 17

      SEP 17

      OCT 17

      NOV 17

      DEC 17

       

      Where they could go and pick as many months at a time, I would rather them see:

       

      Rolling 3 Months

      Rolling 6 Months

      Rolling 12 Months

      where:

      Rolling 3 Months = DEC, NOV, OCT

      Rolling 6 Months = DEC, NOV, OCT, SEP, AUG, JUL

      Rolling 12 Months = Complete Data Set

       

      What I would like is to be able to have a number of KPIs/charts on a sheet that if the filter box was "binned" accordingly would then respond to this bin.  I would like to avoid having to add any sort of reference to time periods to each KPI.