How to show values that exceed the thresholds for three consecutive months
Published: 16 Nov 2023 Last Modified Date: 17 Nov 2023
How to show the values that exceed the thresholds for three consecutive months in the line graph?
For example: Show only the values exceeding 10,000 yen for three consecutive months in the line graph.
1. Create a calculated field as below: name : TS_filter value: WINDOW_SUM(IF SUM([Value])>=10000 AND LOOKUP(SUM([Value]),-1)>=10000 AND LOOKUP(SUM([Value]),1)>=10000 THEN 1 ELSE 0 END)=1 ※pick up the values are exceeded 10,000 for 3 consecutive months, and make it 1. If the whole partition is 1 then TRUE. 2. Drag and drop the field into the filter card, and select TURE. See attachment.
Thank you for providing your feedback on the effectiveness of the article.