Forum Discussion
data visualization & complex dax measurements
Hi ccastelb,
For the additional question, would you please clarify more details? For exmaple, which column do you want to calculate the average value of it? What's the logic?
Also, does "the days between transfers" mean that the max date intervals for each ticket and each transfer? If right, you may try measure below and check if it can meet your requirement:
Interval = CALCULATE ( MAX ( Table[fecha] ) - MIN ( Table[fecha] ), ALLEXCEPT ( Table, Table[Ticket], Table[from], Table[to] ) )Regards,
Jimmy Tao
Hi ccastelb,
For the additional question, would you please clarify more details? For exmaple, which column do you want to calculate the average value of it? What's the logic?
Also, does "the days between transfers" mean that the max date intervals for each ticket and each transfer? If right, you may try measure below and check if it can meet your requirement:
Interval =
CALCULATE (
MAX ( Table[fecha] ) - MIN ( Table[fecha] ),
ALLEXCEPT ( Table, Table[Ticket], Table[from], Table[to] )
)
Regards,
Jimmy Tao
v-yuta-msft Thank you very much for the diligent response, I'll explain my need a bit better with the hope that you can help me
the measures should behave as follows
count for each ticket the amount of changes example:
ticket 8779197 changes 13
ticket 8793872 changes 14
ticket 8795592 changes 10
average 12.3 this would be the first required result
relative to the dates I require something similar but with the days
example:
ticket 8779197
starting date 07/11/2017
Final date 02/09/2018
total days 94
ticket 8793872
start date 10/11/2017
final date 04/02/2018
total days 86
ticket 8795592
start date 11/14/2017
final date 03/01/2018
total days = 50
average 77 this would be the second required result
and the most challenging challenge would be to establish which of the groups is the most delayed in attending their tickets
example: ticket 8779197
group Sum of days consumed
gestion_garantias 11
gestion_garantias_pdts_unisys 75
support_onsite_bogota 11
this table represents the number of days that each group took to take action, which is the difference between a
Annex clarifying image
here for example gestion_garantias_pdts_unisys takes 12 days to move to the group gestion_garantias