I keep getting expression incomplete. I am stuck.
concat(
if(min(${reporting_date_month}) = 1, "January",
if(min(${reporting_date_month}) = 2, "February",
if(min(${reporting_date_month}) = 3, "March",
if(min(${reporting_date_month}) = 4, "April",
if(min(${reporting_date_month}) = 5, "May",
if(min(${reporting_date_month}) = 6, "June",
if(min(${reporting_date_month}) = 7, "July",
if(min(${reporting_date_month}) = 8, "August",
if(min(${reporting_date_month}) = 9, "September",
if(min(${reporting_date_month}) = 10, "October",
if(min(${reporting_date_month}) = 11, "November", "December"))))))))))))
" through",
if(max(${reporting_date_month}) = 1, "January",
if(max(${reporting_date_month}) = 2, "February",
if(max(${reporting_date_month}) = 3, "March",
if(max(${reporting_date_month}) = 4, "April",
if(max(${reporting_date_month}) = 5, "May",
if(max(${reporting_date_month}) = 6, "June",
if(max(${reporting_date_month}) = 7, "July",
if(max(${reporting_date_month}) = 8, "August",
if(max(${reporting_date_month}) = 9, "September",
if(max(${reporting_date_month}) = 10, "October",
if(max(${reporting_date_month}) = 11, "November", "December"))))))))))))
I am currently trying to display Months in a word format instead of a number format for a tile.
Above is what it looks like right now and I want it to say JAN-DEC instead.
This is what the table calculation was and then I have been changing it to the above statement.
This is what the entire tile looks like data wise:
Below is the Reporting Date Month custom dimension”
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |