Average Calculations and Percent Change in Table calculations

Q&A
, , , , ,
1

I have attached the Inputs and desired Outputs

I am trying to calculate the average across each column and percent change from last cell value of the same column and average.

image
image1480×346 31.9 KB

Eg:

  • In Total_1 column 8188 is the average of Total_1 values
  • -2.33% is calculated as ((7997 - 8188)/(8188))*100 from Total_1 values
  • I would like show these averages and percentage changes for each respective column and color code the percent change if possible.

Thanks,
Manoj

2

Hello @Manoj_Virigineni !

I would try this in a pivot table. I can came up with something you can try below using mock sales data:

You will not be able to get the percent change at the bottom of the column like your expected output example but you can do it at the row level.
image

Here’s how I created my percent change fields:
percent change sales =

percentDifference
(
  sum(Sales), 
  [{Order Date} ASC],
  1
)

I used the conditional formatting option in the visual properties menu to apply the color scheme

image
image190×507 16.6 KB

Let me know if this is what you were looking for!

3

Hello @WLS-D,

Thanks for your detailed response, but I would like to have column wise operations which seems like not an option at the moment.

Best,
Manoj

4

Hello @Manoj_Virigineni !

to my knowledge it is not. I will mark this as a feature request for the Quick Sight team!