Forum Discussion
DebbieE
Community Champion
Community ChampionKPIs 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...
kentyler
Solution Sage
Solution SageYou could include another calendar table, linked to the data you want to draw the KPI from. That would allow you another date hierarchy
DebbieECommunity Champion
Community ChampionHow 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