We are reporting on opportunities that are segmented by custom field with two possible types (A and B). We have been able to summarize this graphically in a stacked bargraph, which is perfect - but we would also like to see a moving average line graph overlayed.
We don't want to see averages of A and B, we just want to see the average of the total of A+B and how that has changed on a weekly basis. Something like the below (but accurate!):
Is this possible and if so, how do we go about it?
2 answers
Hi Sharif,
I can't seem to make this work as I do not have a field that I can summarize. The report is a Summary format, structured as follows:
Grouped: Start Date
Group: Type (A or B)
Account Name
The above graphs that I pasted can show the start date grouped by calendar week and it has the grouped Types displaying, but I can't summarize the account name, so I don't believe I can get an average...
