When listing the top 20 companies for hours, how can I remove a company that has no hours?

kim_barragan0126
kim_barragan0126 Member
in Charting

I have listed the top 20 companies (I have hidden the names) but I am getting a company name on top that has no hours, but I can't seem to filter it out. Any ideas i can filter out automatically? I don't want to have to filter each time this card is updated.

image.png

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    You can filter on aggregates. So the field you are using to calculate the bars can be added as a filter using the same aggregate (sum, max, avg) and you can set the filter to anything greater than 0.

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    You can filter on aggregates. So the field you are using to calculate the bars can be added as a filter using the same aggregate (sum, max, avg) and you can set the filter to anything greater than 0.

    If I solved your problem, please select "yes" above

  • kim_barragan0126
    kim_barragan0126 Member

    Perfect! Thank you for teaching me something new. Appreciate the simplicity!

Categories