If the query really isn’t returning any results, there isn’t a way to get it to show anything other than “No Results”.
That said, there’s a really easy way around that, which is to get the query to show results .
You could do this by just adding a measure, of type: count. Even though this query has no results:
meaning there’s absolutely NOTHING happening that day, querying for my count: measure with the same filter returns a nice golden goose egg:
If you add the ID dimension back in, though, it’ll have nothing to group by, and will again return all results. You can only have measures or date fields (which will automatically fill in even if the data isn’t present in the database) in order for this to work. See examples below:
Doesn’t work, since I added another dimension that isn’t a date/time.
See if you can’t remove some dimensions or add some measures to cleverly get what you want! If you’re stuck, maybe post some screenshots (without company info, shouldn’t be too hard if there are No Results ) and we can take a look.