Refer attached Image. The Circled markers are the ones for which the orders are already closed. How do I make sure they do not get displayed on App Map view? The purple icons are the open orders which is correct. I dont want the rest of the icons displayed on map.
You could create a slice and point the map view to the new slice with row condition something like [Order]<>โCloseโ
Tried but couldnt make it work. Geo location is in โCustomerโ sheet while order status is in Order Sheet. In slice I will have to take โCustomerโ sheet. Which formula will I have to use in Slice to check status of order from โOrderโ Sheet?
โCustomer Nameโ is used a ref in โOrderโ sheet to reference to โCustomerโ sheet as shown here.
Please see to the Order Capture Sample to sliced the CustomersTable with Open Order Status :
COUNT(SELECT(Orders[Order Id],AND([_THISROW].[Name]=[Customer Name],[Order Status]="Open")))>0
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |