Depends on how your data is set up, and what field you're blending on.
It's hard to follow all the descriptions and keep all the details straight without an actual workbook. Any chance you can upload a sample workbook.
If you're concerned about proprietary data, anonymize your data as demonstrated in the video linked here:
And I wouldn't need ALL your data. Just a few months, and just enough rows to demonstrate what you're getting there.
Thanks for the reply. Example dashboard is attached.
Based on the parameter “Date Level Selector” I want to calculate number of records (numerator) divided by the membership (denominator), for each row.
Quarter and monthly membership values are aggregating correctly. The problem comes on the weekly and daily tables, because membership’s granularity is monthly.
On the weekly table below for example, I need that membership value 604,484 to repeat until it finds the next membership value (603,071), and so on. Same for the daily table.
Is this doable?
Thank you in advance for your help!
Sample_data_OMS.twbx 2.3 MB
If I understand what you need, see attached.
The [index] calc is just there to help me make sure I was addressing the table direction correctly. When messing with table calcs I almost always do this.
For now, given the example's sheet layout, the default of TABLE(down) for the table calc is fine. You may need to tell that calc to "walk" the table a different way if you have a different sheet layout in your actual application. If you run into that, ping back.
So what makes this work here is the use of the PREVIOUS_VALUE() function. It's a pretty cool tool. It says, "for this calc, pull whatever is in the previous cell of the table into this cell's value." You can use this in place of [Membership] on the viz as I did in this example.
Sample_data_OMS_v10.5.twbx 2.4 MB
Amazing work, Joe! Thanks for teaching me this! Truly appreciated!