I have a repeating group that reads a status table. Within each cell of the RG, I have a group that uses conditions to format the color background to that of the status color. I’d like to show a count of all records with a certain color on the first group that has that color and not on any subsequent ones. I’m not seeing a clear path forward. First item doesn’t work here.
Ok, here’s the background. I originally tried this in a TreeMap visual using a chart plugin. It did almost everything I needed. One requirement though, was the ability to click a segment and have it filter the table displayed beneath this visual. The chart plugin didn’t support click events.
So, in this configuration, I have a repeating group that is reading the project table. No grouping, just sorted on the Latest Project Status Value. Each row of the repeating group contains a group that simply changes color based a condition on what the current cell’s value is.
This enables me to emulate a chart where each color segment is a different length. I can click on the group and do the filtering.
What I can’t do is show the count for the range of color yet. If I group the underlying data, each segment is the same exact length and that’s no good. Thanks for your help!
Currently, I have a separate RG that does the grouping/count and shows the count above this line. If I nest the bar RG into the grouping RG, I get equal length segments which fails the requirement.
Hey @cmarchan I may have found a potential way to do this using @alex4ChartJS plugin. Not sure how I didn’t see this plugin earlier.
The 100% stacked bar chart seems like it may do what I need it to do. It supports the click event, shows the data label, and I think I can hide the grid/series labels as well. That would tick all of the boxes and I avoid a brittle solution to maintain.