Loading

Changing a Constant Reference Line by Filter

Udgivelsesdato: Apr 13, 2024
Opgave
How to create a dynamic reference line that shows a different constant value for different filter values?
Trin
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)
Vidensartikelnummer

001456516

Vedhæftede filer

Reference Line Changes with Filter.twbx

1234 KB

 
Indlæser
Salesforce Help | Article