Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i would like to build an KPI which gives me a count of data (tasks) where the last failed reload time is newer than 24 hours.
My KPI of last reload failure is: timestamp(Max({<[Reload Failure]={1}>} [Reload Finish]))
My problem is now to buold that KPI:
Count
(
{
<
[Reload Failure]={1},
# ? Last reload failure within last 24 hours ? #
>
}
[Task App Name]
)
Anybody an idea how to do that with SET ANALYSIS?
Thanks,
John
Attached youll see my table with the tasks and their last successfull execution time. They are ordered ascending by execution time. I am trying to build a KPI now, which gives my all unique tasks, where the date in that table (last successful execution time) is older than 24 hours.
How is success defined? Using the flag?
Yes: [Reload Failure] = {0}
Try something like this
Count({<
[Task App Name] = {"=Max({<[Reload Failure] = {0}>} [Reload Finish]) = Max([Reload Finish])"},
[Reload Finish] = {">=$(=TimeStamp(Now(1) - 1))"}
>} [Task App Name])
Thanks a lot, this code helped!