Forum Discussion
Modelling issue and totals
The Responses Table are respondents response to a sample survey, one individual can have multiple responses. Individuals have their IDs.
The Table Join Table is a column of unique IDs
The Table Hours are hours individuals worked by month
Here is a look at the model right now
I noticed when I want to slice hours worked by responses, the total never adds up!
I basically want the totals add up.
peterhui50 Yes, it will not add up. if you look at your hours table, total of hours column is 10.00 so total will not exceed 10. However, in your response table, sameID is being used against multiple responses so your sub-total at response lavel would have overlapping values so total of sub-total values will be different from the acutal total in the hours table. i hope you understand the logic. In an ideal scenario, each response should be assinged an unique ID so total hours are calculated correctely at the sub-total level of response.
Thank you, that makes sense.
2 Replies
peterhui50 Yes, it will not add up. if you look at your hours table, total of hours column is 10.00 so total will not exceed 10. However, in your response table, sameID is being used against multiple responses so your sub-total at response lavel would have overlapping values so total of sub-total values will be different from the acutal total in the hours table. i hope you understand the logic. In an ideal scenario, each response should be assinged an unique ID so total hours are calculated correctely at the sub-total level of response.
Thank you, that makes sense.