COUNT IF Expression

[simbai94]

Good Morning,

I have a table with the fields: Site Code, Fault and Months i.e January,Feb, Mar.....Dec.

I would like to create a pivot/chart which shows something like this:

Site Code	Fault	January	February	March	April
ZM001	Transmission FAULT	11	12	25	16
	AC Fault	0	2	0	3
	Water Pump Fault	0	0	0	0
ZM002	Transmission FAULT	18	22	9	20
	AC Fault	2	2	3	2
	Water Pump Fault	0	1	0	1
ZM003	Transmission FAULT	8	16	12	9
	AC Fault	1	1	0	0
	Water Pump Fault	2	0	0	0

So my raw table just contains the Site Codes (ZM001,ZM002.......)  and faults i.e (Transmission Fault, AC fault and Water pump fault.) I would like to produce a table like the one above which will show me the number of times a particular fault occurred over the months based on Site Code. I would then also want to flag or filter those Faults whose count is greater than 10 in a given month and perharps label them as "Violating".

Your assistance would be greatly appreciated. Thanks!

[JustinDallas]

I'm not sure this is a question.  In any case, have you tried looking at the Pivot Table component?  That's where I would start.

[dplr-rn]

Like justin mentioned using pivot table with month as column dimension should give you the look.

But What do you mean by 'label them as Violating'?

     if you mean in script Not knowing your data model hard to give a suggestion.

     if just on the UI. why not change background color e.g. show background color are red if greater than 10