Loading

Changing a Constant Reference Line by Filter

Дата публикации: Apr 13, 2024
Задача
How to create a dynamic reference line that shows a different constant value for different filter values?
Действия
The solution includes creating an IF/THEN logic calculated field.  This calculated field will list constants used for each filter value that is contained with an ATTR() function to prevent automatic aggregation.  See the sample calculation below.

Please review the packaged sample workbook found in the Attachments section of this article to see the resulting solution.  The attached .twbx demonstrates the use of Region as the filter.  The reference line changes by the Region values as shown in this IF/THEN calculation:

ATTR(IF [Region]="West" Then 2000
ELSEIF [Region]="East" Then 5000
ELSEIF [Region]="Central" Then 1000
ELSEIF [Region]="South" Then 3000
Else Null
END)
Номер статьи базы знаний

001456516

Вложения

Reference Line Changes with Filter.twbx

1234 KB

 
Загрузка
Salesforce Help | Article