Filter and Group Table View by Weeks Inside a Month

[Sven_]

I am new to AppSheet, so this might be super easy(and I hope it is), but thank you in advance for your help.

So, I have a table of dates and associated information. I have already used a slice to filter and display only the dates inside of the active months. But I need to go one step farther and group said dates and separate them by week. 

I have a feeling this is done within the same slice but I just can't wrap my head around the date/time expressions enough to figure this out.

Here is the filter condition in my current slice. "AND([Date] <= EOMONTH(TODAY(), 0), [Date] > EOMONTH(TODAY(), -1))"

If you need extra information or are confused as to what I am trying to accomplish please ask me questions.

[VOLODYMYR_TYROL · Accepted solution]

Hi, you can do it in a very simple way, create a virtual column with the formula WEEKNUM([columnWithData]), and later group lists by week on the UX side

https://support.google.com/appsheet/answer/10107425?hl=en

https://support.google.com/appsheet/answer/10106698?hl=en&ref_topic=10101818 

[Sven_]

Thank you, so much!!!! You have no idea how much I struggled to do that. By chance do you know how to change what is displayed on the group heading? Currently, it displays the week number, which isn't the end of the world but it would be nice to be able to change it to something more readable. 

[VOLODYMYR_TYROL]

for personal project i use something like that :

CONCATENATE( TEXT( [Date],"YYYY" ), "_",WEEKNUM([Date]))

[Sven_]

Thank you! I will give it a try.

[VOLODYMYR_TYROL]

you can CONCATENATE() as many columns as you like to get your idea, 

CONCATENATE( Year + WEEKNUM + Status) so in that way, you will get groups for each week with each possible status 

https://support.google.com/appsheet/answer/10107400?hl=en 

[VOLODYMYR_TYROL]

also if you have a lot of data and would like to show it filtered, check this powerful video https://www.youtube.com/watch?v=nK-Aq_ak_T8