I have these fields:
createdAt, ID (both are standard orocrm fields)
What I want to create is a report that shows how many leads have been created on each date, e.g.:
And in the future I would probably like to add some more information (e.g. which person created how many leads on those dates).
I tried the following settings in a custom report:
Columns: Lead>ID (function: count. sorting: descending)
Columns: Lead>Created At (function: none. sorting: none.)
Grouping: Lead>Created At
Grouping by date: enabled. Date field: createdAt.
The only thing this does is create a table with these fields:
TIME PERIOD | ID | CREATED AT
2019-09-03 | 0 | [empty]
2019-09-02 | 0 | [empty]
2019-09-01 | 0 | [empty]
So… it’s not showing any recent dates, ID is always 0 and ‘created at’ is always empty. I’ve tried playing with most settings but am not able to figure it out.
Anyone have any ideas? Thanks!
The forum ‘OroCRM – How do I? Questions’ is closed to new topics and replies.