This content has been marked as final.
Show 2 replies

1. Re: How to create a category(KPI or filter) by comparing last two values
Shinichiro Murakami Oct 9, 2016 9:32 PM (in response to Anu Rekha)Anu,
Here is my approach with using table calc.
[Good Bad]
if
(window_sum( if last()=0 then sum([Value]) end)

window_sum( if last()=1 then sum([Value]) end))
>0 then "Good"
elseif
(window_sum( if last()=0 then sum([Value]) end)

window_sum( if last()==1 then sum([Value]) end) )
<=0 then "Bad"
end
Filter latest 2 days
[Delta last day]
if last()=0 then sum([Value])lookup(sum([Value]),1) END
Thanks,
Shin

Delta_last_day_SM_9.2.twbx 13.2 KB


2. Re: How to create a category(KPI or filter) by comparing last two values
Shiva Krishna Palakonda Oct 10, 2016 12:02 AM (in response to Anu Rekha)Hi Rekha,
Please find the attached workbook for your reference.