Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to name my chart whatever the current selection is but only to the last selection made. So, I have Zone, Unit, Product. I was my initial title to say "Score", then once I've selected Zone, I want it to say "Score Zone" (whatever the zone is they've selected), once a unit is selected it needs to read "Score Unit", therefore ignoring the Zone. Ideas?
Kev
Could you provide your same application.
-Uva
='Score '& if( getselectedcount(Zone)>0, Zone,'')
That just returns the Zone, I want it to change to say the unit once I've drilled into Unit
'Score '& if( getselectedcount(Zone)>0, Concat(distinct Zone,','),'') & if( getselectedcount(Unit)>0, Concat(distinct Unit,','),'') & if( getselectedcount(Product)>0, Concat(distinct Product,','),'')
May be this:
='Score '& GetCurrentField(DrillGroupName)
'score' &score unit
May be this , if u don't want the values of the field, only field name
Score '& if(GetSelectedCount(Zone)>0, subfield(GetCurrentSelections(),':',1),'')
..
..
similar to others
I want the value too, so once I selected Zone A I want the title to say Zone A, then if I selected Unit 3, I want it to say just Unit 3, not Zone A
get selection field(field name)