Populate Last Day of Month or Last Day of Week

[mshevelson]

Hello!

I have a widget in a dashboard that shows the number of subscribers for my app week over week and year over year.  My data's grain is daily per subscription plan per platform.  For example, if we have 10,000 subscribers, then the data looks like this:

Date	Plan	Subscriptions
2/20/2024	Plan 1	4,000
2/20/2024	Plan 2	6,000
2/21/2024	Plan 1	4,100
2/21/2024	Plan 2	6,100

My issue is to show weekly or monthly views, I have to average the number of subscriptions so it averages the total number of subscriptions per week or per month.  I want to only show the number of subscriptions on the last day of the week or the last day of the month.  Has anyone successfully done this before?

[DRay]

Hello @mshevelson,

Have you tried creating date filters to show only the dates you need?

[DRay]

Hello @mshevelson 

I wanted to follow up to see if the solution offered worked for you

If so, please click the 'Accept as Solution' button so that other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.