Hello,
I work with ArcGIS Online and would like to compare transaction figures with the previous year.
The data source contains the data from 01.01.2023 until now.
The data structure looks like this:
Location, event date with time, ID, event type
I would like to evaluate the following in the dashboard:
1. indicator
Comparison of the number of IDs in the current month with the number of IDs in the same month of the previous year. (This means comparing January current with January previous year).
For the indicator, however, I can only select "last month" or "last year" for the reference / filter event date to display data from the last year.
2. row chart or list - I would like to display the 10 different locations in a cross table (row). Locations in a cross table (row, see Excel), the months (columns) and the number of events should be displayed in the body.
Can I display a crosstab in the dashboard from an Excel (CSV) table?
I would appreciate your help.
Thanks Chris
