* It is assumed that the dropdown list has already been populated with a list of dimension objects WidgetsDropdown List: dropdown_1 (referenced using the ‘this’ syntaxTable: Table Script placed in the dropdown onSelect event
Switching Dimensions in/out of a table on specific rows Read More »
* It is assumed that the dropdown list has already been populated with a list of measure objects This script works for bar and line charts WidgetsDropdown List: dropdown_1Chart:Â Chart_1 Script placed in the dropdown onSelect event
Switching Measures in/out of a chart using a dropdown list Read More »
This script allows us to swap dimensions in & out of a table on 2 rows, it ensures each dropdown list contains a unique list of dimensions Trying to add the same dimension twice to a table; inevitably will result in a SAC script error.In the graphic below we can see that the value selected
Mutually Exclusive Dropdown Lists Read More »
* It is assumed that the dropdown list has already been populated with a list of measure objects WidgetsDropdown List: ddl2Table: tbl Script placed in the dropdown onSelect event
Switching Measures in/out of a table using a dropdown list Read More »
This code explicitly references the dimension ID and Description, this prevents the need for a data source query to be triggered.
Apply a dimension filter using a dropdown list without triggering a data source query Read More »
Requirement I want to filter a table by location using buttons e.g. Nevada , Oregon, California. I also want a dropdown so I can filter the table by Sales Manager – but the Sales Manager dropdown must only show managers for the state selected in the location filter, or all Sales Mangers if no location
Restrict dimension members in a dropdown based on another dimension filter(cascading) Read More »
When you add members from a hierarchy dimension to a dropdown it shows all values from all levels in the hierarchy – essentially a flat structure, not user friendly. Using Best Run Juice – Product as an example, the end result we’re looking to achieve is as per below;Just the top level of the hierarchy
One solution is to create a Measure Dimension / Account-Based Dimension.In this example I want to add members of Quantity Sold to a dropdown list. Create an Account-Based Dimension – I named it Q_SOLD2 Script Now we can add the measure dimension members to a dropdown list in the usual way.When typing the script at the
Populate a dropdown list with members of a measure Read More »
