Dates on Chart vs # | Community
Skip to main content
J
JordanMa
Level 4
April 6, 2020
Question

Dates on Chart vs #

  • April 6, 2020
  • 1 reply
  • 467 views

Hello! If I have either a bar chart or bubble charts w. Planned Completion Dates as an axis, is there a way to get the dates to populate vs the month's number? ... (January=1, Feb=2, etc.)

Any insight would be appreciated!

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

    1 reply

    A
    AdamMi
    Level 3
    April 23, 2020

    Hello Jordan,

    I have done some testing on this and this is not possible using the reporting groupings, however I was able to come up with a solution using a custom form.

    To accomplish this you would need to create a calculated custom form field with the calculation of: MONTH(Planned Completion Date). Be sure to set the Format of the field to 'number'. https://drop.workfront.com/v1uDem1l

    This custom form would need to be attached to all object you want to report on. This calculation will capture the month of the Planned Completion Date. ie. 10/15/2020 would be 10 for October. You can then group by this custom field on your report and then chart off of these values.

    Hope this helps,

    Terms & ConditionsAccessibility statement

    Loading footer...