This content has been marked as final.
Show 2 replies
-
Re: KPI - minimum from value
Aar Kay Jul 21, 2017 9:18 AM (in response to Daniel Kuba)may be this:
min (aggr (count({$<[Storage Type]={'FGB'}>}[Empty indicator]),Date))
-
Re: KPI - minimum from value
Daniel Kuba Jul 24, 2017 4:26 AM (in response to Aar Kay)Its work, but isnt it what I wanted. I get daily three files. And min (aggr (count({$<[Storage Type]={'FGB'}>}[Empty indicator]),Date)) give me lowest daily sum for choosed days. I need lowest daily value.
Example:
I have 1.1.2017 - 10, 5, 20 (first value, second, third)
2.1.2017 - 3, 14, 123.1.2017 - 22, 44, 8
And I get as result now 29 (lowest sum 3, 14, 12)
But I need get as result 3 (lowest value from all)
-
příklad.PNG 24.1 K
-
-