Dashboard returns 0 rows / SQL code retrieves results

  • 15 February 2022
  • 1 reply

Userlevel 1

I apologize for the vague title.

A dashboard that was created by my predecessor (no documentation) is not working anymore. It now retrieves zero rows when it was initially displaying sales metrics.

The dashboard uses A LOT of derived tables. I painstakingly took the SQL code apart and ran it in my database: it works successfully and I get data back.

When I click on the option “rebuild derived tables” on each of the tiles, nothing changes. Zero rows returned. No error message. 

Any suggestion what I can check? I am stumped :disappointed_relieved:

This topic has been closed for comments

1 reply

Userlevel 2

Hi ChrisB!


Can you please share us more details regarding this dashboard that stopped working?


Hope this helps!


Best regards,