I have a use case where i have certain questions as a dimension and there are in total 160 of them. We ask each property manager these question but for lets say Property A , we ask 50 questions and for property B we ask all 160 of them.
How do i apply access right so only relevant questions get assigned to each of the properties? It doesnt need user access , just need to define it by property itself and questions.
Secondly, then i need to create a metric to track progress rate as to how many of these questions are still blank and for that as well, i need to divide it by only the applicable questions. So for example property A have 50 questions to answer and he have only done 5 so far, then my progress rate should be 5/50 i.e 10% not 5/160 which is taking the whole 160 questions in the original list of questions.
Best answer by NathanView original