Averages

Question

is there a way to get the average percentage of these 3 columns in the totals, I dont seem to find a way, I will like to have an average of the YOY growth %, dont know why in the total is getting the last balance of 2017

erik_tarnvik · Answer

There is no way to tell unless you provide the formulas and data you used to arrive at this result.

edavila · Answer

What exactly do you need to see&nbsp;thanks for your help

erik_tarnvik · Answer

What do the table(s) that are the source for your results look like? And, what formula did you use for the growth calculations?

edavila · Answer

this is the formula for the cases YOYYOY Cs Growth % = divide([YTD Cases] - [YTD Cases Prev], [YTD Cases Prev],0)&nbsp;for salesYoY Growth % = DIVIDE([YTD Sales] - [YTD Sales Prev], [YTD Sales Prev],0)&nbsp;does this help&nbsp;

erik_tarnvik · Answer

Yes, somewhat. The problem here is that it is not intuitively obvious what a "total" of these YoY columns actually means. From the information you have provided my assumption is that to form the total, the measures are evaluated in the context of all three years, but that still means that the YTD for those three years still evaluates to YTD for this year, and the same applies for the previous year in order to calculate the growth. In some way, this is also reasonable interpretation of what that "Total" should mean, but I understand it is not what you want.&nbsp;&nbsp;The way I would go about this is to remove the total in the table as it is hard to understand what it means anyway. If the average you want is still of value to the user, create a separate visual for that specifically that also clarifies for the user what it is exactly he or she is looking at.

Forum Discussion

Averages

9 Replies

Related content

Average and Moving Average

Weekly Average

Accumulated average

moving average help

Average of Average Pattern Inaccuracies