Dashboard Charting & Data Aggregation
I am beginning to explore the dashboard functionality of SS and trying to get a better grasp of aggregating data in various ways in Sheets. I want to ensure I understand how the data must be organized in order to use charts and other visualizations before I get too far along.
Data must first be aggregated up to the point of rendering the visualization and cannot be displayed across Sheets.
Assuming that's true, how do I best setup an aggregation sheet to take care of this? I've reviewed several templates and other community discussion on related topics, but most of these seem to involve static elements of aggregation. For example, charting Total # of Tickets per User involves a data component such as User which can be dynamic. Do I have to manually insert a row each time a new data value populates or can this be automatically inserted?
Thanks in advance.