Add dates as Columns in table


I'm querying MySQL db to return data to a table. I would like to have one column per date returned. How do I do that?

Right now all I have is this:


You would have to change the structure of the data being returned by the query using a transformer.....
What does your query return now?

Hi @ScottR,
This is the query that I have:

select Date, ifnull(sum(Total Sales (units)),0) as Units
from profitability_table
where SKU = {{dropdown_product.value}} and Date >= {{dateRange1.value.start}} and Date <= {{dateRange1.value.end}}
group by Date

It then returns what you see in the screenshot above.

OK You might want to try structuring the payload to be more like


I think :wink: