Hi everyone,
I was wondering if it's possible to do a sum count of a certain color on a table?
For example:
Is it possible to count the total number of cells in a column that is green?
Is it possible to count the total number of cells in a column that is green?
You don't, generally. You perform such counts or similar logic when the data arrives, and you use the same criteria for counting as you do for coloring. How is the coloring currently applied? (A transform that loops through the data?)
1 Like
The coloring highlights a certain color when the data is within a certain range. In this case, anything greater than 30 will highlight green and anything less then 30 will highlight red. The coding I followed with coloring the table came from here: Cell Color in Perspective Table - #7 by pkhoshroo
That code loops through the data and determines the color to apply. Initialize a counter to zero before that loop, increment it when you select the color of interest within the loop, and write the result to a custom property somewhere after the loop. That custom property would then be bound to a label or otherwise used elsewhere in your UI.
2 Likes