SET ANALYSIS | Within last 24 hours

[schmidtj]

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

[schmidtj]

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.

[sunny_talwar]

How is success defined? Using the flag?

[schmidtj]

Yes: [Reload Failure] = {0}

[sunny_talwar · Accepted solution]

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])

[schmidtj]

Thanks a lot, this code helped!