Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following question.
I'am building an dashboard that makes the order supply backlog clear.
Therefore I want to count the days of the priority of the order with the creationdate.
In the sheet is the date of creation 07.01.2017, priority of the order is D. D stands for 20 days.
So the outcome must be 27.01.2017.
Can anyone help me with this task?
Many thanks,
gr Patrick
What calculation you used for?
Why E needed 3 times in your statement?
This is in a test fase. So thats wrong and i know this. I have changed it to the wright values.
Bud the problem i have is to count the date with prio D that stands for 20 days.
=count({$<[Created On]+[priority,'D','20']>}) bud this is wrong i know.
Please advise in this question..
gr Patrick
Not sure if I have understood you correctly do you want to count the order which is backlog for n number of days ? for that to happen there should be one more date apart from creation date which gives the info of how long the order is held right?
Count ({<Inventorydate= {"<=date(max(Creationdate)+Prio)"}>} order)
Hi All,
I managed to get the correct formula by my self.
This is the dimension expression:
=IF(([Object status] = 'CLSD' OR [Object status] = 'TECO'), 'Order Ready',
IF(Date([Created On]+
if (isnull(Priority), '0',
IF (Priority = 'C', '90',
IF (Priority = 'D', '20',
IF (Priority = 'E', '7',
IF (Priority = 'F', '3',
IF (Priority = 'G', '1',)))))),'DD.MM.YYYY') - Today() <0, 'Backlog', 'In Control'))
The background collor is programmed this way:
=IF(([Object status] = 'CLSD' OR [Object status] = 'TECO'), LightGreen(),
IF(Date([Created On]+
if (isnull(Priority), '0',
IF (Priority = 'C', '90',
IF (Priority = 'D', '20',
IF (Priority = 'E', '7',
IF (Priority = 'F', '3',
IF (Priority = 'G', '1',)))))),'DD.MM.YYYY') - Today() <0, LightRed (),LightGreen ()))
Now it is possible to get the wright information of the balance score cart:
It wil look like this:
Many thanks for helping me out.
gr Patrick