Reporting on busiest days of the week | Community
Skip to main content
W
WilliamHa9
Level 2
January 8, 2021
Question

Reporting on busiest days of the week

  • January 8, 2021
  • 1 reply
  • 420 views

Hello,

I need to write a report that will graph (by % or volume) the busiest days of the week.

We maintain a calendar that tracks issues that are tied to specific days of the week. We would like to write a report which will compile all the Monday entries for the year, all the Tuesday entries, etc...; ideally, a bar chart or list with 7 values. Is this possible?

Thanks,

Bill Harnett

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
January 8, 2021

Hi Bill - Add to the custom form of your issues a field that uses DAYOFWEEK formula. Then you can use a pie chart to get the percentage of the average for the year. The Days are represented by numbers so 1 is Sunday, 2 is Monday, 3, is Wednesday, etc.

    Terms & ConditionsAccessibility statement

    Loading footer...