I’m trying to create an area annotation in a report to show the Month (x axis) with the MIN and MAX Count of Records (y axis). How do I SUM the Count of Records by Month to get these figures?
An area annotation will be the same for the entire chart. But it sounds like you’re asking for an annotation that varies from month to month.
If I’ve misunderstood, then maybe you can explain what you are after, with some exemplary data perhaps.
I’m creating a chart with 12 months. I want an area (across the whole chart) showing the least records and the most (by month). So if I have a month with 12 records, and that’s my highest, 12 would be the MAX, and if my lowest month is 4, 4 would be my MIN, and the area would be from 4 - 12.
Well, assuming your y-axis is Count of Records, it should be as simple as this:
Unfortunately, it shows both MIN and MAX as 1 for me, so I’m assuming it doesn’t SUM per month, but per individual record. (Month is based on a date column.)
I’ve not put much on atm, but I’d expect an area from 1 - 2 from this:
I must be doing something wrong, but I can’t work out what.
Yeah, the problem is that by adding labels to the entities, you are preventing them from being aggregated by month, and so indeed, they are being treated as individual records.
Try removing the labelling (and colouring) to see what happens.
Removing the labels worked, but the colors are going to be more important that the MIN/MAX area, so I guess I’ll leave it.
Thank you for your prompt help, as always!
Yeah, I worked that out when you mentioned the aggregation. The problem is, it won’t be per month, but by state. It’s not a big deal. At least I know why it’s not working now and how to make it work in future! 
1 Like