topic Re: Variable Toggle: Switching between Measures in Integration, Extension & APIs

Variable Toggle: Switching between Measures

Nolan — Tue, 29 Sep 2020 18:24:12 GMT

Good Afternoon Everyone,

I am in the process of creating a sheet where the user can switch between both Sales and Units as seen below:

I am using a variable in both the toggle and the chart to narrow down the selections to one group purchasing organization that contains the customers seen on the chart. For some reason, each individual customer shows the TOTAL Sales and Units for the organization as a whole, rather than the individual statistics.

The variable is defined as follows:

num(Sum({<[GPO]={'BLANK'}>}[Contract Sales]),'$#,##0;($#,##0)')

(BLANK being the GPO name)

Below are the Parameters for both the Extension and the Chart

Variable Extension Parameters:

Chart Parameters:

Does anyone have a way to fix this issue? Thank you in advance!

Nolan

Re: Variable Toggle: Switching between Measures

edwin — Thu, 01 Oct 2020 17:32:45 GMT

this could either be
1. the variable containing your measure has an = sign, meaning it is immediately calculated and becomes a constant.
2. an issue with the data model and not the chart if the dimension and measures are linked together.

other than that, pls show screen shot of the variable definition used in the measure and possibly your load script (just the part with the dimension and measure)

Re: Variable Toggle: Switching between Measures

Nolan — Mon, 05 Oct 2020 18:30:08 GMT

Thank you so much for your response, Edwin.

I have since found a different way around the issue, but really appreciate your help!

Nolan