Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 02, 2020 09:19 AM
Hi!
I am trying to do a summary table of the daily logs I have in another one.
By week, I could potentially link to, and then select the 7 days I need to (see image), but it would become very burdensome for monthly, quarterly and yearly overviews.
I am already using the group by week and other views, but I would need another table to add custom notes to the week without making the daily log rows dirty.
I am sure there is a quicker way, but not sure where to take it from.
Thanks a lot in advance!
May 02, 2020 10:52 AM
Check out the Pivot Block — that gives you the ability to summarize your records, and then “bucket” or “group” your values together over one of several pre-defined date ranges: by day, week, month, quarter, year, day of week, month of year, quarter of year. It’s pretty cool! :slightly_smiling_face:
Also, if you only want to see SOME of your records make it onto your Pivot Block — instead of ALL of your records making it onto your Pivot Block — simply filter your records ahead of time in your table using the “Filter” command.
If you’re using the same filter over & over again, you can even create a new view that has that filter already pre-set.
May 02, 2020 03:48 PM
Thanks a lot! The pivot block may be useful! But if I would like to create a new view that has that filter already pre-set what would be the formula, instead of manually adding the days?
May 02, 2020 04:03 PM
You have tons of filtering options. Just play with them for yourself. You can choose “date is within this week”, “date is within this month”, “date is yesterday”, “date is last month”, etc. Those are just 4 of your many options. There are many different options fo choose from.