Advanced Insights – no filter values solution

Modified on Tue, 30 May, 2023 at 11:51 AM

When applying filters to reports, sometimes you may be presented with the ‘No values available’ message when there should be a list of options to choose from (e.g. departments, locations, divisions etc).


Detailed overview of the issue

If you are building your report and configuring filters:


Only to find when clicking the funnel icon to see a list of options, there aren’t any. Instead, the screen says ‘No values available’:

Why does this happen?

It is triggered occasionally by the combination of filters using a pre-defined date format, and a List format. There is a solution for this.


Follow the below steps to rectify this issue:

  1. Select filters at the top
  2. Select the filter where options aren't appearing
  3. Select value list selection
  4. Cached values on demand
  5. Refresh now on values cached (should go from 0 to a different number)

You should now find when returning to your filters, that the List options are all present.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article