Is there a way to iterate or break an entire widget by a dimension field?
USE CASE: I have a dimension field - let's call it state that has 50 possible values but these change based on the data range selected. I'd like a bar chart with 2 columns # of Yes's and # of No's to break by each state into its own widget instead of the same widget and axis. So if I have only 3 states present for one date range the output would be 3 different widgets filtered (or the appearance of) for the available states. Is there a way in sisense to make this happen? Is this possible in blox?
I've considered creating a bar chart for each possible dimension value then hiding/displaying based on data but that seems terribly inefficient. Any help would be appreciated.
Hi Gramsey.
Would this plugin work for you? https://www.sisense.com/marketplace/switchable-dimensions/
While not the exact solution we adopted -we used a double axis chart - with a global filter for one of the dimension fields. The switchable dimension filter would've worked but we decided on adopting the other option
