Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Is it possible to use a calculated dimension to a drill down group?
i have a drill down group called [Device] , this later contains 2 dimensions : [Category] AND [Model]( seee attached png)
Now once i click on one category A , i acces to the details of this category A ==> [Model AA ], [Model BB ], [Model CC]
Adress Mac |Category|Model|Date|ID_eqt
ggjj | category A | model AA | 02/02/2020 | 123456 |
ggjj | category A | model BB | 05/02/2020 | 123456 |
ggjj | category A | model CC | 08/02/2020 | 123456 |
ggjj | category A | model DD | 10/02/2020 | 123456 |
now what i want to have in my bar chart , once i click on category A, i will have only model DD , it means the last occurence of model in a given periode
Or when i i use only a drill down group in its simple way , i got 4 model for category A
Question : i dont know how to resolve this , should i use a calculated dimension to show the specific model thinking the measures would sum for this model but that doesn't seem to be working , or that i should do a it an expression
as i said i want to display the result in a bar chart
can anyone help me , it's very urgent
it sounds like depending on selection you want a different aggregation. maybe you can create two expressions, one expression is active when no category is selected then use the other expression when 1 category is selected. in that expression you aggregate by Model
it sounds like depending on selection you want a different aggregation. maybe you can create two expressions, one expression is active when no category is selected then use the other expression when 1 category is selected. in that expression you aggregate by Model
@Shinigaloo what is the measure in chart?
When you drill down on a measure in a report with at least one By and one Across dimension field from different root dimensions, the By fields are broken down to their last dimension level, then the Across fields are broken down. The original By and Across fields are removed.