Add dates as Columns in table

Queries and Resources
1

Hi,

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:

image
image935×349 20.8 KB

Thanks!

2

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

3

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.

4

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

{
"eachDateHere":["TotalSalesUnits"],
"eachDateHere":["TotalSalesUnits"],....
}

I think :wink: