Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

data visualization & complex dax measurements

Greetings again to all the members of the community. Again I am here requesting your appreciated help. I have the following data that represents the changes of a service ticket from a help desk. e...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

I dont think i can help here.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ashish_Mathur Do not worry, I am also very grateful for your diligence when you come to my aid.
For now the only thing that occurs to me to model this issue is to manually perform a calculation that indicates the probability of each group at a given time of the calls and represent it as a line graph with the path most likely to follow the services
Thanks for your interest