Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts,
I would like count three columns all together to be in one measure. Is it possible to do that?
Really need your insights.
Thanks in advance.
Regards,
Zety.
It worksssss! Thank you soooo muchhhh! :))))))) Appreciate it a lot 🙂
Appreciate if you can accept the above as solution.
Thanks and regards,
Arthur Fong
sorryy, but the value does not accurate.....
because the condition is to check if it is accident or not. The expression that you gave only applies at Immediate_cause_1. while the Immediate_cause_2 and Immediate_cause_3 does not follow the condition 😞
You would need to provide more info so that we can help:
What is the condition for Immediate_cause_2?
What is the condition for Immediate_cause_3?
If the conditions are the same, maybe try this:
Count({$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}[IIR_INCIDENTMAIN_1.IMMEDIATE_CAUSES_1])+
Count({$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}Immediate_Cause_2)+
Count({$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}Immediate_Cause_3)
Yes, the condition is the same. But, seems like it counts different value because of the dimension.
What should i put in the dimension? Do i need to just input Immediate cause 1 or include everything (Immediate cause 2 + Immediate cause 3) all together?
It depends on your data model and what your requirement looks like.
Do provide more info on your requirements.