[DONE] Reporting... count items per month (unique field)

Hi there,
I try to do a report with leads identified by month… but fail. I have data for all last 12 month. But the newest month shown to me is Jan’23.

I setup the report this way:

Is there something wrong with my configuration of the chart?

The respective view shows the correct test data:

Switch this to the saved view (new) in your other screenshot.

Tried this as well… doesn’t change the diagram unfortunately. I starting to think this is a bug?

Is it grouped by a date field?

Yes. Its grouped by month … own Date Field “identified”, by month.
Oldest first, top 12 should give me the last 12 months, correct?

image

The 19 as for Jan’23 is correct… its just not showing the right months.

“I was holding it wrong.”

Here is the solution. When I looked into @Leo’s video I got the point:

“Top12” really means Top12 values. I wanted to get the “Last12” values instead. Thats not implemented (yet?). So the view with data for this chart needs to be limited to the last 12 month of data. Of course “Top12” than has all last 12 months in the chart (:exploding_head: a bit crazy, “Last12” would be more natural).

So the correct setting should be this - see the “View” field:

image

1 Like