Making a query with 2 count fileds

[mosheva]

Hello!


I want to make a query that will return the number of time a specific item have a failure.
From the failure list I want the query to adds up all the failures that are Like *Wiper* and then count the number of times that item had a wiper failure.

I used the the following query but it doesn't good for me...

field	Location	Item	Failure	Failure
table	SR	SR	SR	SR
total	group by	group by	group by	count
sort
show	V	V	V	V
criteria	1		like *wiper*
or

Here are the result:

location	Item	Failure	CountOfFailure
1	13N	wiper mechanic failure	1
1	13N	wiper stuck during down movement	2
1	13N	wiper stuck during up movement	1
1	25N	wiper mechanic failure	2
1	25N	wiper stuck during up movement	1
1	25N	wiper stuck during down movement	3

Here is what I need

location	Item	Failure	CountOfFailure
1	13N	*wiper*	4
1	25N	*wiper*	6

Thanks!!!

[recyan]

Wherever you have criteria, try replacing "Group By" with "Where" in your query in the "Total" row & see what happens.

Thanks

[mosheva]

Thanks! it is start to look like I wanted...

[recyan]

Glad you found it helpful.

Thanks