Jump to content
  • 0

Interpret Aggregated Average


Patrick0329
 Share

Question

Hi all!

 

Below is the search result of my data page. I want to interpret the General Average this way,

<=75 FAILED

<=90 PROMOTED

<=94 PROMOTED WITH HONOR

<=97 PROMOTED WITH HIGH  HONOR

<=100 PROMOTED WITH HIGHEST HONOR

my General average is calculated by this formula Round(AVG,0)

 

Thank you hope someone can help...

image.png

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi!

Maybe you can add another aggregate function element on the report and paste the following formula there: 

CASE 

WHEN Round(AVG([@field:Final]),0) <= 75 THEN 'Failed'

WHEN Round(AVG([@field:Final]),0) > 75 AND Round(AVG([@field:Final]),0) <= 90 THEN 'PROMOTED'

WHEN Round(AVG([@field:Final]),0) > 90 AND Round(AVG([@field:Final]),0) <= 94 THEN 'PROMOTED WITH HONOR'

WHEN Round(AVG([@field:Final]),0) > 94 AND Round(AVG([@field:Final]),0) <= 97 THEN 'PROMOTED WITH HIGH HONOR'

WHEN Round(AVG([@field:Final]),0) > 97 AND Round(AVG([@field:Final]),0) <= 100 THEN 'PROMOTED WITH HIGHEST HONOR'

ELSE ''
END


Change the Final field in the formula to the field name of your 'Final' column. Hope this helps!

Link to comment
Share on other sites

  • 0

Hey!

No problem! Try this formula instead:

CASE 

WHEN Round(AVG([@field:Final]),0) <= 75 THEN Left((CAST((Round(AVG([@field:Final]),0)) as VARCHAR)),2) + ' - ' + 'FAILED'

WHEN Round(AVG([@field:Final]),0) > 75 AND Round(AVG([@field:Final]),0) <= 90 THEN Left((CAST((Round(AVG([@field:Final]),0)) as VARCHAR)),2) + ' - ' + 'PROMOTED'

WHEN Round(AVG([@field:Final]),0) > 90 AND Round(AVG([@field:Final]),0) <= 94 THEN Left((CAST((Round(AVG([@field:Final]),0)) as VARCHAR)),2) + ' - ' + 'PROMOTED WITH HONOR'

WHEN Round(AVG([@field:Final]),0) > 94 AND Round(AVG([@field:Final]),0) <= 97 THEN Left((CAST((Round(AVG([@field:Final]),0)) as VARCHAR)),2) + ' - ' + 'PROMOTED WITH HIGH HONOR'

WHEN Round(AVG([@field:Final]),0) > 97 AND Round(AVG([@field:Final]),0) <= 100 THEN Left((CAST((Round(AVG([@field:Final]),0)) as VARCHAR)),2) + ' - ' + 'PROMOTED WITH HIGHEST HONOR'

ELSE ''
END

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...