group date

[#1]

Hi ,

I have a date & Qty data as show in image. I want a chart which shows total of qty for every 7 days (not weekly).

Ex: -

Jan 1 to Jan 7th

Jan 8 to Jan 14........

Thanks in Advance

[#2]

Something like this:

Left join <your table name>
Load *, floor(day(Date) / 7) as ChunkOfSevens
resident <your table name>;

After that you can use ChunkOfSevens as Dimension in your chart.

[#3]

Thanks for your reply... Can we do it in the charts directly by any expressions , instead of doing at load script?

[johnw]

Sure, just use floor(day(Date)/7) as a calculated dimension. It'll perform better if you make it a real dimension in the script like Nick suggested, though.

[#5]

I tried that expression but getting nulls..? can you please upload a sample.

[#6]

It shouldn't if you have "Date" field. Do you have Date field?

It will be great if you send us your example.