Divide a column into six different ones, using metrics ?
Hello all, I'm struggling with a report I'm trying to build. I would like to divide the column "Opportunity close date" into six different ones, each one counting the number of opportunities which closing date is within a period of time (different for each column). In my case, the different periods of time are "Actual Month", "Year to date", "Month +1", "Quarter 3", "November and december", "Year". I tried using the function SUM or COUNT, without any luck. I tried with the Bin option, which gave me the formula : case WHEN Opportunity."Close Date" BETWEEN date '2015-07-01' AND date '2015-09-30' then 'Q3' WHEN Opportunity."Close Date" BETWEEN date '2015-11-01' AND date '2015-12-31' then 'Nov y Dic' WHEN Opportunity."Close Date" BETWEEN date '2015-01-01' AND CAST (TimeStampAdd(SQL_TSI_DAY, 0, Current_Date) as DATE) then 'YTD' WHEN Opportunity."Close Date" BETWEEN date '2015-01-01' AND date '2015-12-31' then 'Year' else '' end |