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.
Try this:
Column(1)+Column(2)+Column(3)
Cannot. It returned 0 value 😞
You have a sample app?
I don't have it. But i can give you the example.
Eg:
Dimension : Immediate_cause
Measure : Count (Immediate_cause_1) + (Immediate_Cause_2) + (Immediate_Cause_3)
But it gave me 0 value in return.... 😞
Do something like this:
For your case:
if Count (Immediate_cause_1) is your first expression, then this will be column(1).
Count(Immediate_Cause_2) should be your second expression, then this will be column(2).
Count(Immediate_Cause_3) should be your third expression, then this will be column(3).
So your last expression will looks like:
column(1)+column(2)+column(3)
but I'm using the word cloud graph...there's no multiple measure to add, can input only one measure...
Try this:
Count (Immediate_cause_1)+
Count(Immediate_Cause_2)+
Count(Immediate_Cause_3)
it workssss! But how do i add the condition to only count accident only. Because it doesn't allow me to do nested count.
Right now, the calculation for calculating one measure which is Immediate_cause_1 is :
Count({$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}[IIR_INCIDENTMAIN_1.IMMEDIATE_CAUSES_1])
Try this maybe:
Count({$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}[IIR_INCIDENTMAIN_1.IMMEDIATE_CAUSES_1])+
Count(Immediate_Cause_2)+
Count(Immediate_Cause_3)