Average of 2 Formula Indicators

[groverdhairya]

Hi 

I have created 2 different formula indicators now i want to find the average of the both, but i am having issue in finding results it says no data available. Formula is - ([[CSAT]]+[[HR]])/2.

Please help me find the solution. What can be the issue??

[AndersBGS]

Hi @groverdhairya ,

we need some more information to help you, due to the formula ain’t giving much. What do you want to find the average of?

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[groverdhairya]

Hi @AndersBGS 

The 1st formula is giving the % of survey for Incidents and 2nd formula is giving the % of survey for HR cases, We need to find the average of both.

[AndersBGS]

Hi @groverdhairya ,

Basically, the calculation is done by adding a group of numbers and then dividing by the count of those numbers. So for the survey for incidents you need two automated indicators and a formula indicator on top to do the calculation: [[Sum of survey score]]/[[count of surveys]]. Same goes for HR Cases.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[groverdhairya]

Hi @AndersBGS 

It is already there i found one is having data other doesn't it is showing as no data available, is it works in a same way or it should do the average on one having data.

Thanks