[billyboyo Contributions: 0Level 1☆]

There are a number of examples of saved searches that use formulas to create columns for Monthly Sales totals.

Typically something like CASE WHEN TO_CHAR({trandate},’YYYYMM’)=’201511′ then {quantity} ELSE 0 END. Or something comparable with DECODE.

Next level of sophistication would be to replace the hardcoded ‘201511’ with something like to_char(add_months({today},+1),’YYYYMM’) which would allow you to build a set of rolling buckets extending X months out from {today} . That I can handle.

Next jump would be to support rolling buckets not based on {today}. If the search has an Available Filter like trandate On or After and the users chooses June 1, 2014 is there any way to access that date (i.e., June 1, 2014) and use it in a Formula? I’m envisioning something like {availablefilter.rangestartdate}.

I could then “hardcode” rolling formula buckets relative to the filter date selected rather than {today}
This is a cached copy. Click here to see the original post.

[MikeB1235 Contributions: 0Level 1☆]

Did you ever figure this out? I want to do the same thing with an existing filter value in a Saved Search.

[billyboyo Contributions: 0Level 1☆]

Afraid not. In fact I just went through manually adjusting buckets for 2016.

[Author]

Posts