Calculation Question

[JustinRamsey]

Good Morning,

I am working on adding a couple gauge visualizations to a dashboard I am creating and am needing a bit of help getting my expression to work. I am looking to count Orders only where OrderType = ZVK2,ZVE2, and ZVK3. I tried if(OrderType='ZVQ2', Count(OrderType)) as a test but it returns nothing. 

The two fields are related and are in the same table too just in case you were wondering. 

[m_woolf]

Try this:

= Count(<{OrderType={'ZVK2','ZVE2','ZVK3'}}>OrderType)

OrderType may not be the best field to count. Is there a field like "OrderNumber" that would be a primary key?

Might be better to use:

= Count(<{OrderType={'ZVK2','ZVE2','ZVK3'}}>OrderNumber)

[JustinRamsey]

Yes there is %Key_Order that would be the order number. When I try your expression converting it to the correct field name at the end it shows it as an error and returns nothing. Appears it is considering the { the start of the offence. Any ideas? 

[JustinRamsey · Accepted solution]

AHA! Figured it out! 

Correct function would be COUNT({<OrderType={ZVK2,ZVK3,ZVE2}>} %Key_Order)