making sum of daily averages
So I have a data set which has the a date column and a column that represents a certain value for each date. I have several years of data where I have a single corresponding value but my latest data has multiple values per day - i.e. i have basically an entry for each 5 minutes per day. So when I graph this in a bar chart it shows a daily average for each day, however i can't figure out how I can create an output in beast mode that will show me a sum of all average daily values in any selected date segment.
For example lets say on 1st of a month I have one value of 5$ and so its average is 5$ on the 2nd of the month I have values of $4 $6 $5 and its average is is $5 but if I sum all the values its not the sum of the averages (10) but sum of all the values in the column (20)... so any suggestions will be very much appreciated...