Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Dates on Chart vs #

Avatar

Level 4

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!

1 Reply

Avatar

Level 3

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,