Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am counting inspections based on them being passed:
Count({<[Bascom Pass]={'YES'}>}[Bascom Pass])
Which is working fine, but I need to filter that by the "Inventory Item Type", could someone help me with this?
Thank you!
on which value you want to filter?
field is inventory
what about value?
Hi,
I'm sorry but I don't understand your question.
Why don't you create a chart with the above expression and [Inventory Item Type] as a dimension?
Hey Sunny,
That's what I did and it's counting all of the inventory types for each on:
Can you post an image of your data model?
This seems like a data model issue, but can't pin point it to anything specific... are you able to share a sample?
Of course, thank you for looking over this for me. It's been driving me crazy! I've attached it to the original message.
is it gives you a right value
Count({<[Bascom Pass]={'YES'},[Inventory bason item type]={'Fire Door'}>}[Bascom Pass])