Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am trying to create a KPI that would show me the difference of filtered dates' result against the selected dates same weekdays results, looking back only 4 weeks (29 days) from filtered date.
For example, if I were to select 09.08.2018 from filter then the KPI would show me the percentage of how much different the selected dates result is compared to last 4 weeks same weekdays average result.
I tried to create an expression but it is not limiting the selection to 4 weeks.
=
(
Sum(
{
$
<
TYPE={'10'},
CurYTDFlag={1},
PPR_TYPEID={'1','2','3'}
>
}
RESULT
))
/
(Only(
Aggr(
Sum
(
Total
<
WeekDay
>
RESULT)
/
count(
Total
<
WeekDay
>
DISTINCT DB_KPI_DATE),
WeekDay,
DB_KPI_DATE)))
-1
Can any one please help
Are you doing this in a text box object? Also, it would be easier to make sense of this if you can share a sample app to look at...