Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I actually getting total as 30. Is there any way to show as 15, based on Date.
Date | Value | status |
9/13/2017 | 5 | OK |
9/13/2017 | 5 | NOK |
9/14/2017 | 5 | OK |
9/14/2017 | 5 | NOK |
9/15/2017 | 5 | OK |
9/15/2017 | 5 | NOK |
Total | 15 |
|
May be this
If(Dimensionality() = 0, Sum({<status = {OK}>} Value), Sum(Value))
For the Date 09/13/2017 - value is 5
09/14/2017 - value is 5
09/15/2017 - value is 5, So the Total - 15
if you only want OK status, with set analysis
sum({$ <status={OK}>} Value)
I need both Status
if(Dimensionality()=0,
sum(aggr(sum(DISTINCT Value), Date)),
sum(Value))
May be this
If(Dimensionality() = 0, Sum({<status = {OK}>} Value), Sum(Value))
Thank you Sunny.
Also, I need the difference for Value based on Date,
For 09/13/2017 & 09/14/2017, tghe difference is 0(Zero).
In a new column? May be this
Aggr(Sum(Value) - Above(Sum(Value)), status, Date)
But my requirement,
If the value for 09/13/2017 - 5
and the value for 09/13/2017 - 6. The difference is 1 and it is higher than the previous date. Is there any way to highlight the difference by symbol like (^ or v) increased/decreased?