Forum Discussion
Matrix Row and Freeze columns
Hello everyone, This the first time posting a note. I need help understanding the best way around the limits of the Matrix visual. Currently I have 22 Rows and 1 column that gives me the date by month. The value is volume. When I set it up as a tabular view to get all the Rows, I cannot see the column month data. This will be an ongoing set of values overtime. Any recommendations on how to summarize the data in a way that will give me my desired outcome?
Hi Will_OG ,
Here is my test data:
Based on your description, if you want to aggregate values you can create matrix visual objects, placing the month columns on the rows and the value columns on the values. If you do not want to aggregate all the values of the same month, you can create a table visual object, please note that manually adjusting the month columns and value columns is “ do not summarize”.
If I have misunderstood your needs, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Will_OG ,
Here is my test data:
Based on your description, if you want to aggregate values you can create matrix visual objects, placing the month columns on the rows and the value columns on the values. If you do not want to aggregate all the values of the same month, you can create a table visual object, please note that manually adjusting the month columns and value columns is “ do not summarize”.
If I have misunderstood your needs, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.