Charting

Charting

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

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

  • 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

  • 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

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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In