Add a Pivot Table feature to Table Element in ArcGIS Dashboards

[Yanin]

Currently, ArcGIS Dashboards lacks a pivot table function for the table element, making it difficult to do in-depth data analysis. A pivot table feature would enable users to create tables that group inspections by kind and display counts, sums, or averages across key fields. This function will increase the power of ArcGIS Dashboards!

[MHami]

We also need pivot table functionality in Dashboards.  Currently I have to write code, which won't be supportable after I retire.  Database records in a table aren't efficient when looking at categories of records over time; many users want the numbers vs. a serial chart.  If I could pivot database records by field values that would be great.