Forum Discussion

izzu's avatar
izzu
Frequent Visitor
2 years ago

Trying to Create conditional Column or formatting based on performance

Trying to Create conditional Column or formatting based on Ticket handel (performance) in a Metrix Tabel

Condition should be if - Ticket Assigned No - is More , Breach Ticket No - is Less , Ticket Open No - is Less , Ticket Closed - is more , Work order - is More , SR Created - is Less - Should be Good , then fair , and Poor

Assigned toTicket Assigned NoBreach Ticket NoTicket Open NoTicket ClosedWork orderSR CreatedPerformance 
Lucy1021903Fair
Sam15821328Poor
Rakesh25412452Good
Pamela2002150Good

 

Need Help

4 Replies

  • Bmejia's avatar
    Bmejia
    Super User
    2 years ago

    Hi Izzu,
    You need to provide more information on your calculation.  you telling us that "Ticket Assigned NO  - is more",  more/less then what value? What makes something to have a fair, poor or good performance?


  • izzu's avatar
    izzu
    Frequent Visitor
    2 years ago

    Hi Bmejia , let me try to put another way , in my Metrix visula I have column Agents name and Count of Tickets assigned and ticket status count handel by them (i.e.. Ticket Assigned Count, Breach Ticket Count , Ticket Open Count  , Ticket Closed , Work order , SR Created ) I need to create Performance Column based on tickets handeled , and createria should be based on the Ticket Count and Status Count ( i.e.. Least Breach Ticket , Least Open Ticket , Least Created Ticket, High Assigined Ticket, High Work Order , High Closed Ticket - will Good and Fair and Poor)

    • Bmejia's avatar
      Bmejia
      Super User
      1 year ago

      I am sorry, but I still don't understand how you get to your performance of good, fair and poor.   If somebody understand Izzu please help out.  a example of how you calculate each of the performace would be helpfull do you compare values and give it a score or you multiply or subtract values etc..

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    To be honest, I don't understand your real needs, izzu .

    I can only see that you want to create a conditional column named Performance.

    The Performance column is based on the countings of the previous columns.

    I would like to ask you to explain in detail what constitutes Fair, Poor, and Good in the Performance column.

    For conditinal calculating, we often use IF() or SWITCH() to return results.

    IF function (DAX) - DAX | Microsoft Learn

    SWITCH function (DAX) - DAX | Microsoft Learn

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.