Forum Discussion
Need Help: Quartile Measure Shows Same Values Across Week Without Agent_ID
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.
Hi GeraldGEmerick , for example, the measure selected in the filter and in the week, would be classified by quartile, but understanding what you meant, I would need to count the employee IDs and for each measure I would classify the IDs and the values of the measure, for it to work, any ideas to do this if it is the right thing to do?
andrelopes2711 While I am quite certain that this is not the correct solution that you are looking for, this is something along the lines of what I was trying to convey in my earlier message:
Measure = VAR _result = COUNTROWS( FILTER( SUMMARIZECOLUMNS( dCCC[AGENT_WORKDAY1], "_Classificação Quartil", [Classificação Quartil] ), [_Classificação Quartil] = MAX( TB_Quartil[Quartil] ) ) ) RETURN _resultAgain, I sincerely apologize regarding my lack of ability to understand your predicament clearly.
In this table, I need a view where I select the measure in the filter and it classifies the quartiles. The way it is now, all the values are the same from Q1 to Q4 in each week. I hope I’ve explained it better this time. 😊