Forum Discussion

ajdm2007's avatar
ajdm2007
Icon for Helper III rankHelper III
2 years ago
Solved

Improving my agent card

Hello everyone,   The following DAX formula calculates several performance metrics for the specialists in the technical support department. agent_card = VAR xNew = CALCULATE(COUNTROWS(tickets), ...
General Comment
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ajdm2007 ,

     

    I would suggest trying this approach: create individual measures for each field, such as New, On-hold, etc., and then use a treemap visual to clearly display the proportion of different types within each group. Additionally, you could set up a separate bar chart or table to interact with the treemap. When a user selects any group in the treemap, the detailed numbers for each type can then be displayed.

     

    Best Regards,

    Bof

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ajdm2007 ,

 

I would suggest trying this approach: create individual measures for each field, such as New, On-hold, etc., and then use a treemap visual to clearly display the proportion of different types within each group. Additionally, you could set up a separate bar chart or table to interact with the treemap. When a user selects any group in the treemap, the detailed numbers for each type can then be displayed.

 

Best Regards,

Bof

 

 

ajdm2007's avatar
ajdm2007
Icon for Helper III rankHelper III
1 year ago

Hello Anonymous 

 

It's a great idea.

 

Thank you so much.

 

Have a wonderful Friday.