Aggregate Categorical Data to Simplify Analysis | Product Feedback Forum

bminehart · 2023-05-08T21:55:04.318000Z

We would like to be able to dynamically aggregate different categories of data into a fewer number of categories to make the visualization and analysis of that data cleaner and more Viewer-friendly.Example: I may have records of a color that I want to count on. I may have these possible values: "Red", "RED", "red", "Blue", "BLUE", "blue", "Orange", "ORANGE", "orange", and so on.If I COUNT on these values I may get:"Red": 10"RED": 7"red": 12"Blue": 2"BLUE": 7"blue": 22...and so on..I'm asking for aggregation feature that I, as a user, could define based on the values in these records such taht the data above could be represented as:"Red": 29 (i.e., 10 + 7 + 12)"Blue": 31 (i.e., 2 + 7 + 22)

MoreDiscussions

Aggregate Categorical Data to Simplify Analysis | Product Feedback Forum | Sisense Community