Forum Discussion
Flexible Scoring
I did some data modeling. Please download the file from same location and try.
Thank you so much!
I have tried the solution you have given and it's was fine, though when I applied it to my actual data it doesn't get what I wanted. I think my explanation was bad, my apologies about it.
In lieu with that please see this link https://www.dropbox.com/scl/fi/vcj58m3lcxw7qyyytsgw7/data_new.xlsx?dl=0&rlkey=gxtgucrt0qrtt3s3s54nkv0if for the excel file to what I really want to happen (column G-H) and how I want it to work.
Again my apologies and thank you for your support.
Super UserI think if the issue with the filter applied. This what you need to do. As we are using a simple table to get the overall average, we are forced take all of that table means the filter will not apply. Now create a date table and join with your date. Also, create an employee and Supervisor, using summarize of distinct and try. That should help.
- amitchandak
I did some data modeling. Please download the file from same location and try.
Thank you!