組織を選択
How to show values that exceed the thresholds for three consecutive months
公開日: Feb 14, 2025
タスク
How to show the values that exceed the thresholds 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.
ナレッジ記事番号
001468436
この記事で問題は解決されましたか?
ご意見をお待ちしております。
