How to calculate Percentage and Percent difference week by week?

wanda619 — Tue, 02 Aug 2022 19:53:23 GMT

Hi community,

I am stuck on a problem where i have to calculate percentage and Percent Difference.

I have 3 columns, for example --

Name | Errorcode | Result

abc | 324 | 5

abc | 999 | 1

abc | Total | 6

I want the output to look like this --

Name | Errorcode | Result | Percent of Total | Percent Difference ( week over week)

abc | 324 | 5 | 83.33 | 25

abc | 999 | 1 | 16.67 | 100

abc | Total | 6 | 100 | 100

for Percent Difference (week over week) should look at the errors for that Name from the prior week and understanding the percent difference to this week. Example, if there were 3 1027 errorcodes last week and 6 1027 errors this week the percent difference would be 100%.

topic How to calculate Percentage and Percent difference week by week? in Getting Data In

How to calculate Percentage and Percent difference week by week?