Forum Discussion
Solved
Creating a Matrix Table that shows constant values on the first to columns then values by date.
Hello, I'm trying to create a matrix, (or another visual) like what is shown below. Where the first 3 columns show what is being measured, the low and hig control limits. Then the actual d...
Amy,
Thanks for your ideas. I was able to use the drill down to display what I wanted after some changes in formatting.
Here is a link to the site that guided me through the process: https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Hi,
Create a calculated table of date, PH & Conductivity columns then add limits using union and rows function to the calculated table as two more data points.
This way you can get the expected output.
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
Venkata Nalla
Venkata,
I'm sure that your solution would work if I was more familiar with coding. But I figured how to do it another way.