Forum Discussion

ajdm2007's avatar
ajdm2007
Icon for Helper III rankHelper III
1 year 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

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
1 year ago

ajdm2007 I would definitely see if you could align all of the numbers in a single column left-justified and then, if possible right-justify the category text. You might be better off with using an Enter Data query to create a table of your categories and then revise your measure to just return the numbers for each category. Then you could use a compact table format and have a lot more control over your formatting, colors, etc.

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

Hello Greg_Deckler,

 

Thank you for your reply.

 

I'm not sure how to address your suggest.

 

Could you show me a little an example?

 

Thanks again.