Dashboard limits?

Hi all,
I’m starting to create a Dashboard application and I’m wondering if it’s possible to insert a select instead of flat reference to only one table.
Is it possible with a workaround ? It’s a little pity don’t have these features.

create a view with your select in the the db
then you can use the view in sc

Ok thanks, I’ll try later