Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

Pivot table in Dashboard: Expand rows not working

Solved!
DogaS
Level 3
Pivot table in Dashboard: Expand rows not working

I am using the Pivot Table functionality in the Dashboard. My rows are some hospital names, and I am showing counts of some other variables for each hospital. There are in total 93 distinct hospitals.

When I put hospital name under the row section in the pivot table, it is showing the names of 20 hospitals and clubs the rest as "Other" as the last row in the pivot table.

On the right, there is an option to select as "Expand/Collapse" -> "Expand Rows". I click on this but nothing is happening. I assume that is meant to expand the "Other" row to show individual hospital names.

Can you let me know if this is a bug and if there's another way of achieving my goal?

Thanks!

0 Kudos
1 Solution
SarinaS
Dataiker

Hi @DogaS,

I suspect that there is nothing to be expanded in your pivot table, as the only time the "expand rows" or "expand columns" option will do anything is if there is nested data to be expanded as you can see here
 
Regarding the "Others", if you wish to remove the grouping of "Others" you must uncheck the following option on the column name:

Screenshot 2024-06-03 at 6.45.09 PM.png

Thank you,
Sarina 

View solution in original post

0 Kudos
2 Replies
SarinaS
Dataiker

Hi @DogaS,

I suspect that there is nothing to be expanded in your pivot table, as the only time the "expand rows" or "expand columns" option will do anything is if there is nested data to be expanded as you can see here
 
Regarding the "Others", if you wish to remove the grouping of "Others" you must uncheck the following option on the column name:

Screenshot 2024-06-03 at 6.45.09 PM.png

Thank you,
Sarina 

0 Kudos
DogaS
Level 3
Author

Thank you @SarinaS ! Looks like it was right under my nose

0 Kudos