Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Lets say, I have four fields:
branch_id
branch_name
date
sales
On the chart I used branch_id&' -'&branch_name to display a branch
On the same sheet I have a KPI that I want to be able to alter by selecting dates but not to be altered if branches are selected on the chart
I used sum({$<branch_id=>}sales), it didn't work.
sum({$<branch_id=,branch_name=>}sales), didn't work.
sum({$<branch_id=,branch_name=>}sales), didn't work.
sum({$<branch_id=,branch_name=,[branch_id&'-'&branch_name]=>}sales), didn't work
GetCurrentSelections() results to "branch_id&' - '&branch_name:100-main branch"
If I change the field on the chart from branch_id&' -'&branch_name to branch_id
then sum({$<branch_id=>}sales) works.
Using concatenated fields can cause some strange behaviour. The best way is to create a new field with these 2 fields combined in the script instead of the dashboard.