Can someone help me with a chart showing count of Alignment Scores? | Community
Skip to main content
C
Christina_DeBonis
Level 2
November 8, 2021
Question

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

  • November 8, 2021
  • 1 reply
  • 481 views

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

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

1 reply

C
ChloeRo
Level 4
November 10, 2021

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.

Terms & ConditionsAccessibility statement

Loading footer...