Could someone help me on this? I have two columns PartyType1 and PartyType2. I am trying to create an indicator of the type PartyType1 and 2. For PartyType1, I have 18 Bicycle, for PartyType2, I have 11. Total should be 29 but for some reason the indicator does not count when PartyType1 and PartyType2 are equal to Bicycle.
Hmmm.... I've never seen that error message before. Perhaps an Esri person would know more what that means.
Hi Josh,
Thank you for recommendation. So I tried creating an expression, but I am getting this error Execution Error: Cannot read properties of null (reading 'replace').
Your indicator is going to be counting per row, so if one of your rows has "Bicycle" in both columns, it still only gets counted once.
If you want the total number of occurrences across the two fields, you might consider using a Data Expression. Here's an example expression that calculates a value using two fields: https://github.com/Esri/arcade-expressions/blob/master/dashboard_data/CalculationAcrossFields.md
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.