Skip to main content
ben
ben
Helper ⭐️⭐️⭐️
June 27, 2018
Question

How do you apply date grouping by month with MDA objects?

  • June 27, 2018
  • 3 replies
  • 142 views
I regularly report certain stats to our exec team using the Group By option combined with a Date field. I typically configure the date field to be Month, Quarter, or Year. This is super convenient and makes life easy!

However, I am having trouble recreating that when reporting on the AO Participants object. I think this has to do with it being MDA rather than SFDC data.

Why does that matter?
Is there another way to provide a date grouping in that manner for MDA objects like AO Participants?

Here is a screenshot of what I am facing. Obviously, I'd rather the dates be grouped by month.

    3 replies

    venky_reddy_k
    venky_reddy_k
    Helper ⭐️
    June 28, 2018
    Hi Ben,

    Date grouping/summarization in MDA is currently available only for custom objects. However this is quickly changing as we already worked on supporting it (daily, weekly, monthly, year etc grouping on date columns) for standard and application objects also. This enhancement should be available by Aug' 18. Will update again if there is any change in that plan.

    Thanks
    Venky
      ben
      benAuthor
      Helper ⭐️⭐️⭐️
      June 28, 2018
      Yay! That’s great Venky. It will be so helpful!
      -Ben
      katie_b
      katie_b
      Helper ⭐️
      May 10, 2019
      It appears that this is still not available today, can anyone confirm? Is there a work-around so I can show the open rate for a specific program(s) by month not just a general grouping?

      Katie Baker
      Terms & ConditionsAccessibility statement