cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to iterate or break an entire widget by a dimension field?

Gramsey
8 - Cloud Apps
8 - Cloud Apps

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. 

2 ACCEPTED SOLUTIONS

DRay
Community Team Member
Community Team Member

Gramsey
8 - Cloud Apps
8 - Cloud Apps

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

 

View solution in original post

6 REPLIES 6

Gramsey
8 - Cloud Apps
8 - Cloud Apps

-Using on-prem Linux version 2023.9

DRay
Community Team Member
Community Team Member

Hello @Gramsey.

I see this has not been answered yet, so I am reaching out to internal teams to get more eyes on it.

David Raynor (DRay)

DRay
Community Team Member
Community Team Member

Hi @Gramsey.

Would this plugin work for you? https://www.sisense.com/marketplace/switchable-dimensions/

David Raynor (DRay)

DRay
Community Team Member
Community Team Member

Hello @Gramsey ,

I wanted to follow up to see if the solution offered worked for you.

If so, please click the 'Accept as Solution' button so other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.

David Raynor (DRay)

Gramsey
8 - Cloud Apps
8 - Cloud Apps

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

 

DRay
Community Team Member
Community Team Member

I'm glad you're up and running!

David Raynor (DRay)