topic Re: Multiple IF(Match statements with a Count * XXXX in App Development

Multiple IF(Match statements with a Count * XXXX

rossybearr — Sat, 16 Nov 2024 21:19:36 GMT

So I'm new to this and have been working on a combo chart in which I have a list of Actuals and then I need a corresponding line that shows a theoretical number.

I have a custom dimension:

If( [Incidents: Classification] = 'Fatality (FAT)', 'FAT',

If(Match([Incidents: Classification], 'Lost Time Case (LTC)','Restricted Work Injury (RWI)'),'SA',

If(Match([Incidents: Classification],'Medical Treatment Case (MTC)','First Aid Case (FAC)'),'Ac',

If(Match([Incidents: Classification],'Near Miss (NM)'),'In',

If(Match([Incidents: Classification],'Unsafe Act (UAC)','Unsafe Condition (USC)'),'RS',NULL(),

)))))

My Actual measure is: Count([Incidents: Accident ID])

My Theoretical Measure currently is looking like this:

If([Incidents: Classification] = 'Fatality (FAT)',Count([Incidents: Accident ID])*30000,

If(Match([Incidents: Classification],'Lost Time Case (LTC)','Restricted Work Injury (RWI)'),Count([Incidents: Accident ID])*1000,

If(Match([Incidents: Classification],'Medical Treatment Case (MTC)','First Aid Case (FAC)'),Count([Incidents: Accident ID])*100,

If(Match([Incidents: Classification],'Near Miss (NM)'),Count([Incidents: Accident ID])*10,

Count([Incidents: Accident ID]),

))))

As you can see from the below image, it does the standard count for RS and the * 10 for In but not the other categories.

Re: Multiple IF(Match statements with a Count * XXXX

JustinDallas — Thu, 28 Feb 2019 15:12:36 GMT

Can you give us some dummy data that will allow us to reproduce and replicate what's going on ? The size of that If-statement is approaching unreadable, so I would have to work it in the actual editor to make sure things are "if"-ing out at the correct point.

Re: Multiple IF(Match statements with a Count * XXXX

dwforest — Thu, 28 Feb 2019 21:54:59 GMT

Maybe try an INLINE crosswalk
Weights:
LOAD * INLINE [
[Incident Classifiation],[Weight]
'Fatality (FAT)',30000
'Lost Time Case (LTC)',1000
'Restricted Work Injury (RWI)',1000
...
]
measure then:
Count([Incidents: Accident ID]) * Alt(Weight,1)

Re: Multiple IF(Match statements with a Count * XXXX

rossybearr — Fri, 01 Mar 2019 07:03:58 GMT

I think I have resolved to doing the count in the load and just adding it as a dimension