Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to have a default bar chart coloured.
When a User initially opens the Dashboard, the SLA Entire Risk Engine batch details will appear and where minutes are negative, bars should be red and where minutes are positive bars should be green (will change colour for colour blind people another time).
The code works fine if I don't use a default selection but when I introduce a default selection the positive minutes red instead of green.
If((isnull(Milestone) AND Min({<System={'Source'},Milestone={'Entire Risk Engine batch'},Status={'Breach'}>} Minutes))<0,
rgb(255,110,110),
If((isnull(Milestone) AND Max({<System={'Source'},Milestone={'Entire Risk Engine batch'},Status={'Breach'}>} Minutes))>0,
Green(),
If(Min({<System={'Source'},Status={'Breach'}>} Minutes)<0,
rgb(255,110,110),
Green(),
)))
the problem with that is it actually gets rid of the zero values that are not meant to be excluded
Hello Cameron,
Use this in your Dimension as Date:
= if (isExclusion=0 and Minutes<>0, date(Date, 'WWW DD-MMM-YY'))
Does it help to uncheck ' Include zero Values'?
Have you tried
= if (isExclusion=0 and Minutes<>0, date(Date, 'WWW DD-MMM-YY'))
as Dimension?
Hi, I have just found another issue before I try this. Tue 14-Nov and Wed 15-Nov are not zero refer above image from Nov 17, 2017 10:42 AM . Tue should be 1 and Wed should be 5 minutes. I dont know why.
As mentioned below, there should not be any 0 minutes for Tue 14-Nov and Wed 15-Nov. I found that by checking off the zeroes that certain dates were then not appearing. Not sure why we have zeroes instead of numbers.
The Raw Data tab has the Total = to 0 but the details are at least 1 or above. That looks very odd!
I think your Date assignment to your timestamps doesn´t work correct you can see it here:
I select 15.11.2017 but it shows 16.11.2017
what happens is that the SLA commences on the 15th but most of the activity occurs during the morning of the 16th
If you try my solution it look like your description
Additional you can deselct the the show zero values field.