Variable Extension: Toggling between measures

Nolan — Thu, 09 Jul 2020 16:22:57 GMT

Hello everyone,

I am trying to recreate a sheet that a former colleague created, and am running into some issues.

Above is the basic layout of the sheet, and you can see in the top left corner you can toggle between Units and Sales, which in turn changes the graphs and KPIs.

The top left toggle, which I believe is a Navigation & Actions extension, is defined by these parameters below, where vMeasure is defined as: num(Sum([Contract Sales]),'$#,##0;($#,##0)')

We are looking to add another sheet that looks the same, just with one added table. However when we recreate the sheet to look the exact same except with the added table, the graphs break and the toggle does not work.

Does anyone know where to start in fixing this issue? I am relatively new to extensions and variables in general, so any help would be appreciated.

Thanks

topic Variable Extension: Toggling between measures in Integration, Extension & APIs

Variable Extension: Toggling between measures