Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Wael
Contributor
Contributor

KPI For Dimension

Hello everyone hope anyone can help me 

i have a filter pane with field (CommitteeName)

and i want to create a KPI for field (PeriodNumber) which is a Dimension

so i want when i select the data in the filter pane i want the periodNumber for the committeeName to Appear 

how can i do it ?

 

1 Solution

Accepted Solutions
brunobertels
Master
Master

in a KPI object try with concat 

KPI 

concat(distinct periodNumber ,'-') 

distinct to display unique each distinc value 

'-' : used as separator between period number 

View solution in original post

1 Reply
brunobertels
Master
Master

in a KPI object try with concat 

KPI 

concat(distinct periodNumber ,'-') 

distinct to display unique each distinc value 

'-' : used as separator between period number