Advice creating a graph for two field using distinct and multiple fields in that expression.

[wschefter]

Hi all;

Here is what I am trying to do:  I need to create a graph for a single expression, in this case "Order Reason", but only for 2 of the 12 fields in that expression.  I know I can use a filter pane but our executive staff will be reviewing this data and I don't think they need to use a filter pane to get the data quickly.  They don't have the time. 

I have tried writing the following querey:   count([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr])

Expression:  Order Reason

fld:  Tool/Upgrade Part Failed On Install (w/in 30 days)

fld:  Spares Part Failed On Install (w/in 30 days)

Any help would be greatly appreciated.

Thanks.

Will S

Here is the full list of fields within the expression:
 

Order Reason

Damaged by FSE During Installation

Normal Wear and Tear

Other

Part Lost / Misplaced by FSE

Part Mis-Ordered by FSE

Part Missing from Spares Order

Part Missing From Tool Shipment

Received Spare Part Damaged

Received Tool/Upgrade with Damaged Part

Spares Part Failed On Install (w/in 30 days)

Tool/Upgrade Part Failed On Install (w/in 30 days)

Wrong from Previous Spares Order

[sunny_talwar]

Not sure I understand, but do you have a field called Order Reason which can have 12 possible values and you want to only Count where the values is one of the two you listed? May be this

Count({<[Order Reason] = {'Tool/Upgrade Part Failed On Install (w/in 30 days)', 'Spares Part Failed On Install (w/in 30 days)'}>} Measure)

[wschefter]

Hi Sunny;

Thanks for replying.  You are correct in your thinking, I probably just didn't write it correctly.  Within the expression Order Reason I am looking at only pulling the count for Tool/Upgrade Part Failed On Install (w/in 30 days) and Spares Part Failed On Install (w/in 30 days).

I copied the formula (query?) and my results gave me a graph that had a zero count for both fields and a graph that had range of -10 to 10.  I have hopefully pasted in a picture of the results I am getting.

Like I said, thank you for replying, the help is greatly appreciated.

Will

[sunny_talwar]

What expression are you using?

[wschefter]

Sorry for the slow reply.  I am using Order Reason​ for the expression.

[binujose1982 · Accepted solution]

Hi,

Please give filter in Dimension.

if([Order Reason] = 'Spares Part Failed On Install (w/in 30 days)' or [Order Reason] = 'Tool/Upgrade Part Failed On Install (w/in 30 days)' , [Order Reason], null())

Also check the 'Suppress When Value is null' checkbox in Dimension tab.

[wschefter]

Thanks everyone for your help.  Both answers got me to what I needed to do.  I appreciate the help greatly.