Forum Discussion

tanmaym93's avatar
tanmaym93
Frequent Visitor
4 years ago

Average Calculation in Table Visual

Hi Community - I am trying to obtain the Average Headcount (in Average HC) column in a table visualization; however I need some help with the calculation.  The average HC will be calculated as follo...
Need Help
tanmaym93's avatar
tanmaym93
Frequent Visitor
4 years ago

Hi Selina - This is the result I am looking to achieve, however my HC value is calculated as a Sum of the HC column that I have in my dataset..

My dataset has 18k rows and I have assigned the value "1" for all the rows.

 

 

 

As a result, I am unable to obtain the result through the Cumulative value measure you suggested.

 

Let me know if you need additional information from me that can assist you.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi tanmaym93 ，

 

I am not sure I have understood what you mean.

so this HC value doesn't the actual data?

and this is the new HC value which needs to be calculated average value?

If it is convenient for you, you can send me a sample data

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly