Loading

How To Label Specific Points Above A Reference Line

게시 일자: Apr 29, 2025
과업

How to display label specific points above a reference line.
 

단계
To show labels for specific points above the reference line for view like below where the reference line value is 50000:
User-added image

1. Create a calculated field called All points above reference line with the following formula:

     IF SUM([Sales])>50000 then SUM([Sales]) end

2.  Create a calculated field called index with the following formula:

     IF NOT ISNULL( [all points above reference line]) then
     INDEX()
     END

3. Create a calculated field called Rank with the following formula:

     RANK([index], 'asc')

4. To show the first point above reference line, create a calculated field called Final Label with the following calculation:
     If [rank]=1 then ([all points above reference line]) END

5. Drag Final Label to Label on Marks Card 
 
Knowledge 기사 번호

001456862

첨부 파일

Example.twbx

1184 KB

 
로드 중
Salesforce Help | Article