For a simple view -- just one Mark with Measure Names / Values -- i'd like to setup:
1) a TopN Filter (for the x2 number of recent dates);
2) a FIXED LOD expression using MEDIAN() aggregation (to split into two Date Bins);
3) a number of Measures (as Quick Table Calculations --> Difference along Date Bins)
4) a LAST()==0 Table Calculation Filter (to show only the recent Date Bin Mark).
Please find the attached.
Hope it could help a bit.
TEST_v10.5_YF.twbx 922.7 KB
This worked and simplified my original approach. I just need to reframe the title of the visual so that the user understands how the parameter works and what data they are viewing (e.g., if you select 4, you are comparing the most recent 2 records against the previous 2 records for a TOTAL of 4 records).
If I have any questions or further advancements to this analysis I will post for your knowledge.
James, you're welcome.
I have a follow-up question that extends the simple view you created to include a time dimension. Let me know if you have any thoughts to what I have detailed below:
Desired Solution: Using the DATE BINS you created, I need to show each bin over time for certain metrics. We can use the measure "Visits Depth 2 or Greater" as the metric test subject. The date dimensions to be used are DAY and DATE FIRST CREATED PUBLISHED. I need to show the metric "Visits Depth 2 or Greater" for each of the DATE BINS from the minimum DATE FIRST CREATED PUBLISHED for each PAGE NAME within the bins through the first 30 dates within DAY (even if there is no data for a DAY within the first 30). Remember the DATE BINS are showing the 'n' most recent blogs and 'n' previous blogs based on the user-selected parameter - # BLOGS (x2) - so this functionality would need to apply to this line chart over-time as well.
Issues: I am having a difficult time getting each of the DATE BINS and respective PAGE NAMES to have the same starting point of 0 based on their minimum DATE FIRST CREATED PUBLISHED. If we can get each to have the same starting point of 0, we can then use DAY to show the first 30 days of activity for each bin.
I've tried a number of approaches, so just curious if anything pops into your head. I've reattached your workbook with only the appropriate fields needed here. Let me know.
I beg your pardon for my late reply,
and i would apologise once again,
because i'm not quite get your latest reply.
Where is the DATE Dimension in the data?
How could i play with?
And what would be the difference
between the Desired Solution
and the one you've got on the Sheet 1?
I've modified the Table Calcls a little bit,
so the results on the Sheet 1 (and Sheet 1a)
are in sync with those on the Sheet 7.
Please find the attached w/mods.
TEST_v10.5_mod_YF.twbx 950.5 KB