add 3 columns in one measure

[nurulizzaty]

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. 

[Arthur_Fong]

Try this:

Column(1)+Column(2)+Column(3)

[nurulizzaty]

Cannot. It returned 0 value 😞

[Arthur_Fong]

You have a sample app?

[nurulizzaty]

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.... 😞

[Arthur_Fong]

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)

[nurulizzaty]

but I'm using the word cloud graph...there's no multiple measure to add, can input only one measure...

[Arthur_Fong]

Try this:

Count (Immediate_cause_1)+

Count(Immediate_Cause_2)+

Count(Immediate_Cause_3) 

[nurulizzaty]

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])

[Arthur_Fong]

Try this maybe:

Count({$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}[IIR_INCIDENTMAIN_1.IMMEDIATE_CAUSES_1])+

Count(Immediate_Cause_2)+

Count(Immediate_Cause_3)