I have a scenario , where I want to compare yesterday's value with monthly average and determine the deviation.
Now ,I want to compare "Count" column with "GroupAverage" and flag accordingly.
"GroupAverage" is calculated for every group.
Any input will be much appreciated.
A bit of confused as your sample date just contains one day and not sure how you get the monthly average and can you also tell what should be the result and how it calculated?