How to get a Daily Average for the Total Sum of Each Group in my data table
I am working with a rather large data set (aprox 50k data points per day), where each row is a record that has a VOLUME and a GROUP identified within each record. Approximately 10 groups in total, and the dataset is 90 days of info.
I am needing to display (preferable in a line graph where each date is the x-axis) what the daily average sum of VOLUME is for each GROUP.
Any help is much appreciated!