Using data_group function to show two separate date formats?
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