Forum Discussion

jsuh's avatar
jsuh
New Contributor
10 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 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....

fusioncharts_la_ga.png

 

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