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).
Jan 1 to Jan 7th
Jan 8 to Jan 14........
Thanks in Advance
Something like this:
Left join <your table name>Load *, floor(day(Date) / 7) as ChunkOfSevensresident <your table name>;
After that you can use ChunkOfSevens as Dimension in your chart.
Thanks for your reply... Can we do it in the charts directly by any expressions , instead of doing at load script?
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.
I tried that expression but getting nulls..? can you please upload a sample.
It shouldn't if you have "Date" field. Do you have Date field?
It will be great if you send us your example.
Retrieving data ...