Forum Discussion
Change matrix visual layout to show data on two rows
Hi
I'm currently presenting performance data in a matrix with the below format:
To easier get an overview of the two value sets I would like to present the matrix in the below format
I've tried reading about the 'drill down' and 'Stepped layout' actions, which I suspect is the way to go. However I must admit I'm unable to figure it out. Can anyone please help??
Hi KasperFB ,
Do you want base on row instead of column to show the columns in matrix-value-field? Here I suggest you to try "Switch values to row" function.
My Sample:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi KasperFB ,
Do you want base on row instead of column to show the columns in matrix-value-field? Here I suggest you to try "Switch values to row" function.
My Sample:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rico Zhou
This is exactly what I was trying to do.The "Switch values to row" function did the trick.
Thank you very much for your assistance 🙂
- NikhilChenna
Skilled Sharer
hi KasperFB ,
Its very simple, if you have the Availability and Corrected as values in one column. If , yes then you can directly drag and drop it in the Rows option below the Unit.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!Nikhil Chenna
I'm not sure what you mean. I have the values as two seperate columns yes.
When I drag and drop them to the rows under the unit, it divides the rows into the values instead of "uptime" and "incl service".
