Dashboard returns 0 rows / SQL code retrieves results

ChrisB
Participant I

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:

0 1 186
1 REPLY 1

leobardor
Participant V

Hi ChrisB!

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

Hope this helps!

Best regards,

Leo

Top Labels in this Space
Top Solution Authors