jsuh
10 years agoNew Contributor
how to create a 2d bar chart with dates on the y-axis?
Hi all,
I'm trying to create a 2d bar chart. I would like it to look like this http://screencast.com/t/OzdpE5YwXV
The la target and ga target dates are user selected in a custom field of type date.
To get this 2d bar chart to show, it seems I have to in the final sql select, have both a "group by" and a "sum". But I can't do a "sum" since the chart I want is in a datetime format.
What I have so far is this....
But i did this by converting the datetime into an int before i did the final sql select.
How would I go about doing this so that the dates show instead of integers?