Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I’m looking at creating a calendar view dashboard which is able to flag (change colour) when a value on a particular day breaches a consent level. In other words, if a value on a particular date breaches, the cell on that date is highlighted. I have looked that using a calendar object however this does not satisfy my requirements. What I would like is to have a dashboard with a monthly calendar view as seen below. Any ideas please?
Mon | Tue | Wed | Thurs | Fri | Sat | Sun |
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 | 31 |
Thanks,
Hi Mike,
You can create a pivot table like this. In my app I have calendar with fields InvWeek and InvWeekDay. The Background colour is set to: if(sum(Qty*[Unit Price]) > 100000,RGB(250,250,210)). No invoicing on Sat or Sun in my data.
InvWeek | InvWeekDay | Mon | Tue | Wed | Thu | Fri |
---|---|---|---|---|---|---|
26 | 01/07/2016 | |||||
27 | 04/07/2016 | 05/07/2016 | 06/07/2016 | 07/07/2016 | 08/07/2016 | |
28 | 11/07/2016 | 12/07/2016 | 13/07/2016 | 14/07/2016 | 15/07/2016 | |
29 | 18/07/2016 | 19/07/2016 | 20/07/2016 | 21/07/2016 | 22/07/2016 | |
30 | 25/07/2016 | 26/07/2016 | 27/07/2016 | 28/07/2016 | 29/07/2016 |
A little more work can give you a straight table like this:
Mon | Tue | Wed | Thu | Fri |
---|---|---|---|---|
01/07/2016 | ||||
04/07/2016 | 05/07/2016 | 06/07/2016 | 07/07/2016 | 08/07/2016 |
11/07/2016 | 12/07/2016 | 13/07/2016 | 14/07/2016 | 15/07/2016 |
18/07/2016 | 19/07/2016 | 20/07/2016 | 21/07/2016 | 22/07/2016 |
25/07/2016 | 26/07/2016 | 27/07/2016 | 28/07/2016 | 29/07/2016 |
The first column shown has expression : Max({$<InvWeekDay = {'Mon'}>}[Invoice Date]) and Background Colour set to:
if(sum({$<InvWeekDay = {'Mon'}>}Qty*[Unit Price]) > 100000,RGB(250,250,210))
The first column is the dimension InvWeek which I have hidden using the option in the Presentation tab of the chart properties.
Hope this helps
Cheers
Andrew
Brilliant,
It's worked. I now need to work on the background colour as this is a rate of change expression.
Thanks again.
Hi Mike,
Glad to be of help!
All the best
Andrew