<!-- DataSources -->
<%
date_filter = 5.weeks.ago.strftime('%Y-%m-%d 00:00')

query1 = "Date, B, sum(MValue) "
condition1 = "where (MName='Gross Sales' and date > '#{date_filter}') "
grouping1 = "group by Date, B order by Date, B "

ds = datasource("ce_data_template", query1+condition1+grouping1)

print(ds, :format => :debug)
%>

<!-- HTML -->
<% column_chart(ds, :style => "ce_column_chart", :width => '100%', :height => 300) %>