Trying to figure out a conditional formatting formula for a Widget. I have the color formatting working with hard coded values, but I want to have different values with a CASE statement based on today's date and I just can't figure out the formula.
What I want:
Case
WHEN [today's date] < [fixed date I need to use] THEN [value]
WHEN [today's date] < [next fixed date] THEN [next value]
etc.
ELSE [final fixed value]
END
What I don't know how to do is return "today's date" in formula form for this test. Basically, I need the Analytics version of getdate() in SQL. Anyone know how to do this?
DJ
For the two "middle dates" then, I can't do that "out of the box" because those dates aren't values I can type into either the TR_SEASON table or the T_PROD_SEASON table anywhere that would feed into Analytics currently. This would be a customization that I'd have to work with Consulting to do (since we are a RAMP client). Good suggestions though on the Production Season Opening Date and Performance On Sale dates. Are those values by MOS or just the minimum date assigned to either the Production Season or Performance?
Without customization, the ideas that come to mind for hijacking other date fields include:
Hi Chris-
My Membership Team was having a conversation with me just this morning about Customizations for Analytics. Are they possible? If so, do I put in a Ticket to get the conversation started or connect with someone. Anything else I should know to pass along to them? Thank you!
Hi Mark,
Nothing more to get started. Just open the ticket with a quick summary of what you'd like to accomplish that may require customization, and they'll take it from there.
I would love to know more about this.