Heatmaps

Question

&nbsp;DescriptionAn heatmap&nbsp;is a graphical representation of data where the individual values contained in a matrix are represented as colors. This R script shows an heatmap of calls received during the week. Based on the the timestamps it calculates the count per weekday/hour.&nbsp;&nbsp;&nbsp;Prerequisites (The sample .pbix files will not work without these prerequites completed)1. Install R EnginePower BI Desktop does not include, deploy or install the R engine. To run R scripts in Power BI Desktop, you must separately installR on your local computer. You can download and install R&nbsp;for free from many locations, including the Revolution Open download page, and the CRAN Repository.&nbsp;2. Install the required R packages.Download the R script attached to this message and run it to install all required packages on your local machine.&nbsp;&nbsp;Required&nbsp;R packages:dplyr, ggplot2, ggthemes, zooTested on:CRAN 3.3.1, MRO 3.3.0, powerbi.com&nbsp;&nbsp;

mike_honey · Answer

There doesnt appear to be any R script attached to this topic?

anonymous · Answer

I wish I'd seen this posting before I started my example...:smileyhappy:

My version uses the same ggplot and geom_tile functions as fathomson but, rather than use R to massage the data with dplyr etc., it links directly to fields dragged from PBI - a typical Date dimension column and uses a calculated Time Bucket column as the other dimension against which to map the Call Count measure. I DO use the 'complete' function from the 'tidyr' package to fill in missing values and avoid holes in the heatmap.

I also played with presenting the value of the measure on the tile and some other formatting options. I tried to use the viridis palette package, but it's not supported on PBI Service yet.

Required R packages: ggplot2, ggthemes, tidyr. (see attached R script)

Matrix Heatmap

Matrix Heatmap.pbix511 KB

ScriptInstallPackagesForMatrixHeatmap.R1 KB

vrocca · Answer

Here are the links to download the packages referenced:

dplyr: https://cran.r-project.org/src/contrib/dplyr_0.5.0.tar.gz

ggplot2: https://cran.r-project.org/src/contrib/ggplot2_2.1.0.tar.gz

ggthemes: https://cran.fhcrc.org/src/contrib/ggthemes_3.2.0.tar.gz

zoo: https://cran.r-project.org/src/contrib/zoo_1.7-13.tar.gz

Alternatively, you can install these throug R Studio by clicking on Packages > Install and entering the name of the package.

Hope that helps.

fathomson · Answer

Anonymous&nbsp;Looks nice and thanks for adding the R installation script!&nbsp;vrocca&nbsp;Thanks! In R studio I usually&nbsp;use the&nbsp;install.packages('packagename')&nbsp;to add a new package. And above your script or markdown document&nbsp;library('packagename')&nbsp;&nbsp;

sclark · Answer

Is there any way we could change this from a count per hour / day. To an average count per hour / day?