OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

Forums OroCRM OroCRM – How do I? Questions Creating a custom report with grouped date

This topic contains 1 reply, has 2 voices, and was last updated by Andrey Yatsenko Andrey Yatsenko 3 weeks, 4 days ago.

  • Creator
    Topic
  • #38689

    marcel2
    Participant

    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.:

    2019-04-24 43
    2019-04-23 33
    2019-04-22 51

    etc.

    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:

    Entity: Lead
    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!

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No