Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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?

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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