Screenshot of the data is attached, what I am trying to achieve is, I need percentage to be calculated for [Sum(test lookup)/ 12] -> 12 is basically no. of months in a year.
Problem Statement: In the view only pincodes will be shown (screenshot is filtered for 1 pincode), against each pincode I need to calculate seasonal performance percentage which is as below-
For every combination of year-month-pincode: no. of complaints is calculated. If this is greater than 150 then a flag is to be calculated which will be 1 else if its not greater than 150 then this flag will be set to 0. Now sum of all these 1's against combination of year-month-pincode should be summed up and divided by 12, which will give me seasonal performance percentage in return.
Please help!!
Hello Nitish,
I suggest utilizing a Packaged workbooks: when, why, how for other users of the community to more fully assist with this.
Thank you
Patrick
Become a Viz Whiz on the Forums! Support the Community and master Tableau.