Calendar dashboard

[#1]

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,

[effinty2112 · Accepted solution]

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

[#3]

Brilliant,

It's worked. I now need to work on the background colour as this is a rate of change expression.

Thanks again.

[effinty2112]

Hi Mike,

                    Glad to be of help!

All the best

Andrew