I am developing an operations dashboard to visualize crop production data for US States. I have this data for more than 20 years. The information of Years and States is in rows while the yield information for different crops, e.g., soybean, corn, etc is in columns. I want to add category selectors in a way that users can specify years, states and crops simultaneously to visualize the production data on the map.
Adding selector for year and States is straight forward. However, the crops are in columns and I cannot treat them the way I wanted. So, is there any way that I can make a list of all these columns?
Note: I tried using transpose function in ArcGIS Pro where I transposed all those columns to a single column naming "Crops" and their production to "Yield" but somehow, the web layer is not working correctly in ArcGIS online.