0 Replies Latest reply: Aug 23, 2016 2:54 AM by Jan Ellers RSS

    Multiple Time Periods with different dates - how?

    Jan Ellers

      Hi,

       

      I have a tricky one. I got two KPIs lets say "sales" and "accidents". I have defined 4 time periods "current", "before", "previous" and "year on year". And i have data per calendar week.

       

      Now the definition of what is current, before and so on can change.

       

      For "sales" Current is:

      CW15 - 2016

      CW16 - 2016

       

      and for "accidents" Current is:

      CW16 - 2016

      CW17 - 2016

       

      same for the other pediods in the past - e.g.:

       

      For "sales" previous is:

      CW01 - 2016

      CW02 - 2016

       

      and for "accidents" previous is:

      CW02 - 2016

      CW03 - 2016

       

      In the Dashboard I want obviously only show one listbox where the user can select a time period as filter option.

       

      How do i do this?

       

      Before i had multiple values for multiple time perdiods i just had a mapping table (see below)

       

      Now how could i do this? Adjusting calculation formulars by set analysis would not be an issue

       

      CWPeriod
      CW15 - 2016Current
      CW16 - 2016Current
      CW01 - 2016Previous
      ......