Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello friends
For every Date I want count KPI_names where avg KPI_value by KPI_name <1
i try this expression, but it doesnt work
= count ( {<aggr(avg(KPI_value), KPI_name) ={'<1'}>} distinct KPI_name)
Let me know if anyone has idea or decision of this.
Thank you in advance
Ruslan
Thanks Sunny for provided solution!