Latest Contributions by DataOfficer

I'm wondering if anyone can assist with a data expression, or let me know if what I am aiming for is not possible.  I have a dataset from wildlife monitoring, which captures the date of a species observation, the lifestage (e.g. adult, juvenile), the sex (male, female, unsexed) and the quantity (integer) observed. Multiple observations can occur on the same date. Each combination of the above fields is on a separate row (i.e. in 'long' format). Example below. date lifestage sex quantity 01/03/2025 adult male 2 01/03/2025 adult male 5 01/03/2025 juvenile   3 02/03/2025 adult female 8 05/03/2025 metamorph   1 05/03/2025 adult male 3 12/03/2025 adult   12 14/03/2025 adult female 6 14/03/2025 adult female 4   I am trying to use the Dashboards Table element to produce a summary table of this data, where each date is represented as a row, and then subsequent columns show the daily total for each lifestage*sex combination. For example: date adult male adult female adult unsexed juvenile metamorph 01/03/2025 7 0 0 3 0 02/03/2025 0 8 0 0 0 05/03/2025 3 0 0 0 1 12/03/2025 0 0 12 0 0 14/03/82025 0 10 0 0 0   I've gotten so far using Filter and GroupBy statements to summarise counts by day (e.g. resulting in the table format below), but I've not been able to produce a 'wide' format table. Is there any way of doing this? date type total 01/03/2025 adult male 7 01/03/2025 juvenile 3 02/03/2025 adult female 8   I have based my code so far on this example: https://github.com/Esri/arcade-expressions/blob/master/dashboard/dashboard_data/CombineMultipleLayers(SerialChart).md, but instead of referencing different layers for each variable, I have tried setting up multiple FeatureSets from the same layer, each with a different filter applied (e.g. for each 'type' above).  I have also produced something similar to my incorrect output above using the List element, but it still doesn't achieve what I am after. Any help would be hugely appreciated.     ... View more

We have a series of hosted view layers which require their filters to be added/amended. Previously we have been able to share these layers in Shared Update groups to allow other users other than the item Owner to update the view (via Settings > Update View). However, today I have tried to repeat this process, and after clicking on Update View, the initial screen loads but the header ('1. Choose layers' and '2. Define view...') is greyed out, and none of the left-hand bar loads, meaning that the user cannot set or amend the view filters or fields. I have checked the user permissions, group and item settings and sharing and as far as I can tell, these are correct. The Group settings are as follows: The user is a Creator type with the following role privileges: The item settings are as follows: Here is an example of the greyed out view the user experiences: Greyed out header and no left-hand bar If this is no longer supported, the only alternative I can think of is to reassign ownership of the layer to the user doing the editing. However from testing this it looks like I would have to also reassign ownership of the 'parent' layer and not just the view, which is far from ideal. The documentation doesn't provide much detail on this specific issue, so I'm hoping you knowledgeable folks might have some ideas. P.S. can't log with support right now as My Esri is down at the time of writing this. Many thanks. ... View more

I have spent the last 20 minutes trying to access My Esri on various browsers but all are infinitely loading or returning a 504 Gateway Time-out error. Ironically I therefore can't log a support case for something else because the support system appears to be down. Is this a wider issue? Or just me? ... View more