Forum Discussion
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...
You could include another calendar table, linked to the data you want to draw the KPI from. That would allow you another date hierarchy
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