Forum Discussion
Solved
How to count across rows in a matrix visual
Hi Team I am compiling a fairly decent set of data where I have data across 11 columns that contain true/false. It's an attendance list and I only care about those who attended. I've created a m...
Can you unpivot the source table so that each week isn't a separate column but rather a single column with the value indicating the week that it belongs to? This would normalize your dataset and make this kind of modeling easier to work with.
For example take this
and turn it into this
Can you unpivot the source table so that each week isn't a separate column but rather a single column with the value indicating the week that it belongs to? This would normalize your dataset and make this kind of modeling easier to work with.
For example take this
and turn it into this