Forum Discussion
customisable matrix view
Hello,
In my report I would like to present some data in table where I define each box. My data are all in one row and I would like to make 2 visual.
Here's a simplified version of what I'd like to do
Data :
View that I would like(after a drilltrought on an equipment) :
Currently the only way I've found to do this is with cards and text box, but it doesn't give a good result:
I can't unpivot my data because I have too much calculation to do and and these calculations depend too much on the nature of the data.
3 Replies
I can't unpivot my data because I have too much calculation to do and and these calculations depend too much on the nature of the data.Unpivot your data.
Then in your matrix visual you can re-purpose the column total to show the average instead.
Hello,
The average is one of the reason why I can't unpivot data, because it's not a simple average, but a weighted average dependent on a parameter.You can implement that logic in the measure for the column total.
Remember that in a matrix visual each measure is calculated four times.
