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

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.