Forum Discussion
Need Help: Quartile Measure Shows Same Values Across Week Without Agent_ID
- 1 year ago
Hi,
I removed the agent_id from rows of the table and i still see different quartiles. What is the problem?
andrelopes2711 The overall problem that I perceive here is that the TB_Quartil is not related to anything. This is not necessarily an issue but then you need to form the relationship within the measure itself and that is not being done either. It's difficult to understand how to fix the issue necessarily given that I am unsure of what you would like the results to be. In general, you would have to create a table within your measure, add a column to it using your quartile classification measure, get the max quartil from TB_Quartil table and then filter that table down and do some kind of aggregation. That's the general steps that I can more or less deduce from your file and explanation but not really able to proceed further without additional information.