Skip to main content
andrew_snell
andrew_snell
Contributor ⭐️
March 9, 2018
Question

Report On Objectives by Customer by Due Date Classification (Overdue, Today, Next 7 Days, Upcoming)

  • March 9, 2018
  • 1 reply
  • 34 views
I'm attempting to build a dashboard report that rolls up Cockpit data into a stacked bar graph. 

Requirement is:

Count of Objectives
By Cockpit Status (Overdue, Today, Next 7 Days, Upcoming)
By Account Name

Account name should be the bottom Axis, and the Stacked bar above each account should show a breakout of Objectives by Cockpit Statuses

Having a hard time figuring out how to do this.

Thanks!
Andrew

    1 reply

    mindy
    mindy
    Helper ⭐️
    March 10, 2018
    I can't find a way to do exactly what you're asking, but this might be close enough to help. The field it seems like you want to group by is "Overdue Type" but if I drop that into the group by, it throws an error.

    The layout on the screenshots below allow you to see the number of objectives by account and whether or not they are overdue (but not more granular than that). You can get more granular by clicking within the report to see whether the Objective is "overdue", "open", or "due next 7 days".

    Here's the configuration set up and what the report looks like:



    Clicking into the report:



    Would this work for you?
      Terms & ConditionsAccessibility statement