Hello community, I have a feature layer with the following structure
FERIADO | HOTEL | Dia1 | Dia2 | Dia3 | Dia4 | Dia5 |
Feriado1 | Asher | 5 | 2 | | | |
Feriado1 | Casa Loma | 8 | 9 | | | |
Feriado2 | Asher | | | 8 | 2 | 5 |
Feriado2 | Casa Loma | | | 5 | 3 | 5 |
I want to be able to show in a list on a dashboard the total sum of each day. Example
- Día 1: 13
- Día 2: 11
- Día 3: 13
- Día 4: 5
- Día 5: 10
I can't find how to iterate in the feature layer to add up the values for each day. I tried to make a script in Arcade inside the List element with a for to go through it but it didn't work. Please, any ideas to solve this?