I have my data in Data Fabric and I am pulling a field called create date which has date in beginning and has few numbers decimal and then few numbers and ending in Z, I have pulled this in Birst and in my connect I could convert this as a date field dd=mm-yyyy. This is a attribute field now. I want to take difference from current date fpr whivh i am using NOWDATE for ⁰the latest refresh for the report. I am doing this to achieve a days bucket type of logic say
IF (DATEDIFF(DAY, [Hierarchy.create_date], NOWDATE) <= 30) THEN '0-30 Days'ELSEIF (DATEDIFF(DAY, [Hierarchy.create_date], NOWDATE) <= 60) THEN '31-60 Days'ELSEIF (DATEDIFF(DAY, [Hierarchy.create_date], NOWDATE) <= 90) THEN '61-90 Days'ELSE 'Over 90 Days'END
My question is i am getting error while creating custom attribute can some guide me how to create the custom attribute correctly or how can u achieve what I am trying.
