Knowledge Drop

Why do I see "no results" when drilling from a measure?

  • 5 April 2021
  • 0 replies
  • 550 views

Userlevel 5

Last tested: May 14, 2020
 

When I drill into a measure, such as a count, I see what is filtered on, and then the query shows "no results"

This can occur when there is an error in one of the fields being retrieved. Try "explore from here", or check the Admin -> Queries panel to see if there are any queries with errors. From there, the query can be opened in SQL runner to debug it.

It could also be the case that there just aren't results. Check the drill_fields parameter for the measure and verify that the generated SQL should produce results in their data. (You can get the generated SQL for the drill in the Admin > Queries panel).


Or if you enter a new row limit, hit run, then you can now see the results. This could be due to the drill querying having cached results.

 

This content is subject to limited support.                

 


0 replies

Be the first to reply!

Reply