I was able to use a join to create a SQL view from 2 pivot â€˜tablesâ€™ , then pull that â€˜viewâ€™ into an External BAQ.
Having trouble embedding the resulting Dashboard, but the BAQ seems to work fine.
---In firstname.lastname@example.org, <r.oo@...> wrote:905.702
I'm not sure if this is possible, but I have a number of SQL Pivot tables that I've created with dynamic column names (months/weeks ect). Is there a way of having a External BAQ pick up such a table?