Hi Jonathan,
Here is a more detailed explanation.
My code at the moment may have
= count({<[CCS CM] = {1}, [CCS_SubscriberStatusActive] = {1}>}SubscriberKey)
Elsewhere I may have a formula of the form:
= count({<[FSB CM] = {1}, [FSB_PackageStatus] = {1}>}PackageKey)
Both would give "current month" figures - as you may have guessed I have several calendars - I have a CCS calendar and an FSB calendar - hence the flags "CCS CM" and "FSB CM"
I have other flags in my calendars such as "xxx CY" for current year, "xxx CQ" for "current Quarter" etc...
I want to give the user the option to select from a list of metrics from a drop down list that will contain:
- Current Year
- Current Quarter
- Current Month
I created a table
CurrentOptionsMap:
LOAD * INLINE [
TimeText, TimeVariable
'Current Month', 'CM'
'Current Year', 'CY'
'Current Quarter', 'CQ'
];
When the user selects an option I want it to use that metric to construct say "CCS CQ" for the current quarter where the CCS calendar is used etc ... so in the first example it will be something like:
= count({<[CCS "$(=TimeVariable)"] = {1}, [CCS_SubscriberStatusActive] = {1}>}SubscriberKey)
and in the 2nd:
= count({<[FSB "$(=TimeVariable)"] = {1}, [FSB_PackageStatus] = {1}>}PackageKey)
etc...
Hope this is clearer..
