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