Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago

KPIs using None Standard date Periods

say you have the following KPI based on a Monthly report Indicator: Fact Target Goal: Last Month fact Trend Axis Date (Month from the data hierarchy)   But I also have reports based on Tim...
Need Help
DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago

thanks for the offer. 

 

Im going to have to rethink this, with it being a customer report I cant really show it so I would have to set up another test report which may take a while.

 

I genuinely think the answer is that the KPI must include something from a date hierarchy so if you dont use standard date periods you cant base a KPI on it.  which is a real shame

kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

You could include another calendar table, linked to the data you want to draw the KPI from. That would allow you another date hierarchy

  • DebbieE's avatar
    DebbieE
    Icon for Community Champion rankCommunity Champion
    6 years ago

    How though

     

    How could I create another date table using the flags in Dim date I have already set up?

     

    date                  flag

    01/01/2010      1

    02/01/2010      1

    03/01/2010      1

    04/01/2010      1

     

    Take date Between Min date and Maz date Where flag = 1