topic Re: View a KPI for a rolling 13 week period in App Development

View a KPI for a rolling 13 week period

jgreen95 — Mon, 20 Dec 2021 21:38:40 GMT

I am trying to calculate a KPI value for a rolling 13 week period.

The Count distinct element works fine,

[Actual End Date-Inspection Logged.MyCalendar1.WeekEnd] is retuning the correct date

I have then set [Current Week-13} as a variable using a formula to calculate the correct date.

Using this as my formula:

COUNT(DISTINCT{<[Inspection Category]={"Category A"}, [Actual End Date-Inspection Logged.MyCalendar1.WeekEnd] >[Current Week-13]>} INSPECTION_NOTICE_ID )

Any help would be very useful

Re: View a KPI for a rolling 13 week period

sunny_talwar — Thu, 03 Oct 2019 17:55:18 GMT

May be this

Count(DISTINCT {<[Inspection Category] = {"Category A"}, [Actual End Date-Inspection Logged.MyCalendar1.WeekEnd] = {">$(=[Current Week-13])>} INSPECTION_NOTICE_ID)

Re: View a KPI for a rolling 13 week period

jgreen95 — Thu, 03 Oct 2019 18:15:20 GMT

Doesn't work unfortunately, do you know any other way to do a count of only rows in a table with a certain date?

Re: View a KPI for a rolling 13 week period

JGMDataAnalysis — Thu, 03 Oct 2019 19:14:07 GMT

What does the [Current Week-13] variable contain?

Count(
{<
[Inspection Category] = {'Category A'},
[Actual End Date-Inspection Logged.MyCalendar1.WeekEnd] = {">$(=[Current Week-13])"}
>}
distinct [INSPECTION_NOTICE_ID]
)