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%.
