would be grateful for assistance with my problem, I have a table that contains locations/areas with daily inputs (one week range), however some of the locations inputs twice a day. I wanted to calculate sum of inputs and its percentage per week with the two conditions: locations with 1 input and the other having 2 inputs.
This follows a rating scale of 1 to 10. i.e. Location 1 - day1: 10 / d2: 0 / d3: 6 / d4: 8 / d5: 10 / d6: 0 / d7: 5 Location 2 - day1: 9 and 8 / d2: 5 / d3: 2 and 5 / d4: 6 / d5: 0 / d6: 10 and 9 / d7: 5 and 7
Thank you.
Aucun commentaire:
Enregistrer un commentaire