Calculated Attribute: Return Attribute Value with Highest Count | Community
Skip to main content

Calculated Attribute: Return Attribute Value with Highest Count

  • February 27, 2020
  • 1 reply
  • 0 views
P

Is it possible to create a calculated attribute that would check a field's attribute value and return only the one with the highest count?

For example, If I have my Metric as Unsolved Tickets, and these tickets have the custom field 'Issue', I would like to check the count for each type of issue, and have it only show the one with the highest number.

It is simple enough to create a query that shows a break down with the count for each of the issues in this dropdown, but am struggling to go beyond that in this scenario.

    1 reply

    Marie-Cathrine

    Hi Paul,

    From what I understand, you are trying to create a query that displays only the ticket issue with the highest number of unsolved tickets. You can do the following to get only the highest number without having to create a calculated attribute:

    1. Select metric 'Unsolved tickets'
    2. Select your issue field as an attribute (rows)
    3. Click the 'Result manipulation' button (↓↑)
    4. Click on 'Sort' and select 'Value descending'
    5. Go back to 'Result manipulation'
    6. Click on 'Top/bottom' and select 'Top' and put in 1 as the value
    7. Optional: Set 'Visualization type' to KPI (this will display only the number of tickets)

    I hope this helps you.

    #helpsome regards,
    Marie-Cathrine Sørensen
    Business Intelligence Analyst @ helphouse.io

    Terms & ConditionsCookie settingsAccessibility statement