Forum Discussion
Custom correlations or visuals
I'm no statistician but, following the sample, I think you're right:
- Unpivot the values for each hour (i.e. highlight Name and Date, then Unpivot Other Columns),
- Rename the values columns to reflect the variable - e.g. "Number of errors", "Total proc time", "Volume of messages"; then
- Merge the three tables on Name and Date and Time Band with your three variables then on each row, unless you want to build table relationships etc..
Then add a corrplot visual via R per the sample. Note that as of yesterday's update, you can alternately add that specific corrplot as a custom "R-powered visual" via https://app.powerbi.com/visuals/ So far though, I've found no way to customise the plot with that custom visual, rather than writing it in R.
My quick test seemed to work per below screenshot, though all the zeros for Errors didn't seem to help. As I say, I'm no statistician - good luck...
I'm no statistician but, following the sample, I think you're right:
- Unpivot the values for each hour (i.e. highlight Name and Date, then Unpivot Other Columns),
- Rename the values columns to reflect the variable - e.g. "Number of errors", "Total proc time", "Volume of messages"; then
- Merge the three tables on Name and Date and Time Band with your three variables then on each row, unless you want to build table relationships etc..
Then add a corrplot visual via R per the sample. Note that as of yesterday's update, you can alternately add that specific corrplot as a custom "R-powered visual" via https://app.powerbi.com/visuals/ So far though, I've found no way to customise the plot with that custom visual, rather than writing it in R.
My quick test seemed to work per below screenshot, though all the zeros for Errors didn't seem to help. As I say, I'm no statistician - good luck...
Brilliant Steve:
Let me try this out and see if it works. The chart is exactly what I am looking for. Truly appreciate your insights.
Aj