Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Using data_group function to show two separate date formats? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using data_group function to show two separate date formats?

Accepted answer
29
Views
3
Comments
edited Sep 6, 2018 7:04PM in Reporting & Analytics for B2C Service 3 comments

Content

Hello -

I am trying to utilize the data_group function to show two separate date formats within one column, if possible. For example, data would show as Year/Quarter for all items with an active date prior to 2018, but would show Year/Month for 2018 items.

Current formula - date_group(incidents.c$date_active, $date_group) - where $date_group is a predefined list set formatting as Year/Month.(Image of current view attached)

Proposed formula (that doesn't work as currently built, but gauging if I am on the right track) - if(sysdate() >='01/01/2018', date_group(incidents.c

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!