Seleccionar una organización
How to show values that exceed the thresholds for three consecutive months
Fecha de publicación: Feb 14, 2025
Tarea
How to show the values that exceed the thresholds for three consecutive months in the line graph?
Pasos
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.
Número del artículo de conocimiento
001468436
¿Resolvió este artículo su problema?
¡Háganos saber cómo podemos mejorar!
