Forum Discussion

jsuh's avatar
New Contributor
9 years ago

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

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?


No RepliesBe the first to reply