Date Table - 4 week Period

[spandy34]

Hi  wondered if you could help me.  I have a date table linked to a data table but I am wanting to present the following report that works in 4 week periods based on the Date of Visit.  What coding would I need to put in the column to look at the DateofVisit and put in the relevant period number outlined in the example below. If there are any other ideas as to how to present this please let me know.  

Thank you for your help

@goncalogeraldes 

[SergioSilvaPT · Accepted solution]

Hi @spandy34 ,

You can create a matrix with the dates in the columns, then click to show more options on the dates and chose New Group.

Then, create the groups as intended.

There isn't an option for weeks you can choose 28 days, that is similar time frame.

The result isn't exacly like you request but the result is.

Regards,

Sérgio Silva 

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.