I have a dataset in which I need to calculate the monthly average using the daily counts. So I need to include both the field for the date, and the month (I am not a developer so can’t change these options)
So after a complicated calculation, I have yielded the right results, but I only want a to view monthly, but there are as many rows as are days. Is there any way to fix this visualization?
The data set looks like this:
The visualization is reflecting this:
Rather than the number of rows equivalent to days, I just want 12 rows to display the months, if that makes sense. Any ideas?