Cross-tab report: with list of days or weeks

I need to create a cross-tab report for which I am following the guide but stuck in “bi_dynamic_header dataset” where I need the data for daily bucket instead of monthly in the example. Can anyone share an example SQL or JPQL for this band?