using a CTE in a dashboard widget?

Hello,

Is it possible to use a CTE in a widget? I have some SQL code to find contributions with a purchase to a specific production season, and would like to use it in an indicator widget. Is that something that one (who is smarter than me) can do?

Thanks,

Lesley