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]) )
Another idea is to add a filter to each widget that filters them to only order dates within the last 12 months (or whatever timeframe you want).Click Advanced and change the count to 12.You do get different months. The one on the left started in November, while the right one started in May. They'll just need to look for this month's name (April in this example).
If you change the filter to Last 6 Months and change the Design to Half-Year View, they would all look the same.
Thanks for your ideas too Neil!
Unfortunately they still only start at the first month that they took orders (e.g. this Host began working here in February).