Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a bar chart which has 1 dimension and 3 measures; the dimension is name and the 3 measures are late on arrival, on time and early
The bar chart is to show a count of how jobs are late on arrival, are on time and are early per person selected
I have these calculation:
Late - Count(if([Todays Date]>'0', [Todays Date]))
On time - count(if([Todays Date]<='0' or [Todays Date] >='-14', [Todays Date]))
Early - count(if([Todays Date] <'-14', [Todays Date]))
When checking the bars, the late and on time measures are showing the same. Im sure I have missed something and have been looking at this for too long so it is likely very obvious.
Thank you in advance for your help
On time should be AND .. not OR.
On time - count(if([Todays Date]<='0' AND [Todays Date] >='-14', [Todays Date]))
On time should be AND .. not OR.
On time - count(if([Todays Date]<='0' AND [Todays Date] >='-14', [Todays Date]))
That worked a treat - so simple as well. Thank you so much