Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Can someone help me with a chart showing count of Alignment Scores?

Avatar

Level 2

I need to create a bar chart showing the number of projects that are => 45 of the Alignment Score and < 45. Would anyone be able to help me with this? I tried creating the report using filters, but am not able to get the count shown. The bottom axis is showing the actual scores and I would like to just show the total record count number of projects => 45 and < 45 in a bar chart. Do I need to create a custom calculated form for this? Hoping this is a simple one.

Thanks, Christina

0694X00000G73XZQAZ.png

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 4

I think a custom field is probably the best way to accomplish this. If you're adding the field on a project form, this would be the formula:

IF(Alignment>=45,">=45","<45")

Then you can set up grouping by that field. If you don't already have it set up, I'd recommend having a "Admin Use" form onto all templates. That way, when you have a reporting field like this one, you can pop it into the admin form and it already exists on all jobs, so it's just a matter of recalculating the expressions.