Tagging if a value exists in a dimension based on a different dimension

[LawrSam12]

Hello,

I'm hoping someone can help with this.

I have data which contains an Order Reference, Task Title, Task Create Date and Task Closure Date.

What I need to do is create a formula which checks whether or not a specific Task has been triggered within each Order, and then find the time between

At the moment the only formula I've got is

If([Task Title] like '1234*' And [Task Open Flag]='1' And NetWorkDays([Order Create Date],today())<15, 'GREEN'

Which obviously has no relation to the order, but in the graph I've created using this formula I am counting the orders so it's not pulling through properly.

I also then need to be able to say 'if the task isn't on the order before TODAY-5 working days, then RED'

Is there a way for this to happen?

Thanks so much for your help

[Anil_Babu_Samineni]

If each dimension is not related each absolutely there is no auto associate model in your script. Hence, Try to create model such a way with one primary key for all dimension and fact tables.

Are you sure you want to fill all three conditions from given expression below for GREEN?

If([Task Title] like '1234*' And [Task Open Flag]='1' And NetWorkDays([Order Create Date],today())<15, 'GREEN'

[LawrSam12]

Thank you for your reply.

The tasks are related to the orders, but I don't have access to any of the load scripting to see how they are related.

Yes I need all three to be true for it to be tagged as green (there are also red and amber lines of formula as well in a similar format but with different networkdays values)