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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ashish_Mathur I really appreciate your help, this solution presents a difficulty and is that as you can see in the example and in the information the same ticket number passes several times through the same group and then move on to others, this really complicates things because I want to represent that linearity that is following the ticket.
for example for the first service:

support_consent_reg_occident
  >> support_onsite_bogota
   >> gestion_garantias
    >> support_onsite_bogota
     >> gestion_garantias_pdts_unisys
       >> gestion_garantias
         >> support_onsite_bogota
           >> gestion_garantias_pdts_unisys
             >> gestion_garantias
               >> support_onsite_bogota
                 >> gestion_garantias_pdts_unisys
                  >> gestion_garantias
                   >> gestion_garantias_pdts_unisys
                    >> gestion informatica inventory sm colombia

 

anexo ejemplos de como se sankey para este tipo de información
ajustando el parametro de visualización en
"draw backward link" o "duplicate"

 

As you can see, the visual representations are confusing and I want to see it more clearly

thank you can you help me again

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