KNOWLEDGE BASE

How to show values that exceed the thresholds for three consecutive months


Published: 16 Nov 2023
Last Modified Date: 17 Nov 2023

Question

How to show the values that exceed the thresholds for three consecutive months in the line graph?

Environment

 
  • Tableau Desktop

Answer

For example: Show only the values exceeding 10,000 yen for three consecutive months in the line graph.
User-added imageUser-added image
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.
Did this article resolve the issue?