Forum Discussion

mshevelson's avatar
mshevelson
Data Storage
02-20-2024

Populate Last Day of Month or Last Day of Week

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:

DatePlanSubscriptions

2/20/2024

Plan 14,000

2/20/2024

Plan 26,000
2/21/2024Plan 14,100
2/21/2024Plan 26,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?

2 Replies

Replies have been turned off for this discussion
  • DRay's avatar
    DRay
    Admin
    03-04-2024

    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.