Hi all,
I'm working on a dashboard that will show us the frequency that our Hosts are working (to help with training/knowing when people haven't worked for months etc). Not the usual use of Analytics, but the data is there, so why not?!
I've made a heatmap widget for each Host (about 40 with a mix of fulltime/parttime/casual) and it works well, essentially looking at what dates they have each made orders.
However, it's a little tricky to compare them all side by side, as they all start on different months, depending on the first month that they made orders (so are new staff might have February as their first month on the heatmap, but others might have June). Obviously, as it's looking at Order dates, it's producing an accurate heatmap; but I'm just wondering if anyone can think of a formula that might force the heatmap to start at June (even if no orders until Feb etc). (It's probably a no, but thought worth asking the geniuses on here!
A snapshot of some below:
Many thanks,Alison
Hi Alison,
I love it! If you remove the widget filter for the host person and add it into the value formula, we can probably get the missing months to appear...
IF( ISNULL( ([# unique Order ID],[Solicitor Display Name = Host1]) ) ,SUM(0) ,([# unique Order ID],[Solicitor Display Name = Host1]) )
Thanks for your idea Chris! Unfortunately with Heatmaps you can't add multiple things there, and I already need the date and count.
Sorry for the confusion by showing that example formula as a Pivot table. Just flipping it to a Calendar Heatmap widget looks like this:
CSRSales.dash