How would I be able to filter all Detroit inbound and outbound results for a Yes compliance? If I select to filter Detroit on inbound it ignores outbound Detroit values because there were not any inbound shipments going from the same place.
My end result would be Detroit: total yes compliance = 3 ; total no compliance = 4; overall count = 7
I would, in the end, have to find total compliance for each location and other analysis of course.
Thanks for any help!
InboundOutboundCompliantDetroitNew YorkYesDetroitNew YorkNoDetroitNew YorkYesDetroitNew YorkNoDetroitNew YorkNoCincinnatiNew YorkNoCincinnatiLas VegasYesCincinnatiLas VegasYesCincinnatiDetroitYesCincinnatiDetroitNoCincinnatiHoustonNoCincinnatiHoustonYesCincinnatiTampaYesNew YorkHoustonYesNew YorkTampaNoNew YorkNew JerseyNoNew YorkToronto
No
Hi Trent,
I'm not sure there is any way to achieve what you are looking for with filters using a single data source. You will most likely use a combination of parameters and calculated fields. You said that you want to use the result for other analysis. This will depend on what you mean by "other analysis". This is because you can only display the result one location at a time.
I used the following steps below;
1. Create a [Select Location] parameter.
2. Create a [Location] calculated field which references the [Select Location] parameter
3. Use LOD expressions to calculate [No Compliance], [Yes Compliance] and [Total Compliance]
Hope this helps.
Ossai
