Hey Qliksters,
I have a use-case where a user wants to calculate for N number of objects per week, how many days a KPI’s daily value crossed a threshold.
As an example:
Given these rows below, in a separate table, calculate per object per week how many days had a value greater than 3.
![image.png image.png](/t5/image/serverpage/image-id/41096i4277A5817DF1139C/image-size/large?v=v2&px=999)
Some conditions/things to keep in mind:
- The actual data is at the 15 minute level, so I don’t think we can just write: count({<Fact1 = {">3"}>}distinct Date) because the threshold is based on the daily value)
- There are 800 million+ fact rows in the actual data set, so it would not be ideal to have a unique key per row of data to "force" the set analysis to calculate row-by-row. I tried and hit a calculation timeout
- count({<uniqueRowKey= {"= sum(aggr(sum(Fact1),uniqueRowKey)) > 3"}>}distinct Date)
Any tips and tricks?
Thanks!!!
S