Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help setting up dynamic chart title. I need the title to show customer satisfaction rating for last month like below
May: 4.5
June: 4.75
Below is my code
To get the month
NUM('date(AddMonths(Today(), -2),'MMM')
To get customer satisfaction rating
Sum({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating])
/
Count ({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating]),'##.00'))
I need to combine both codes to get May: 4.5
Try:
=date(AddMonths(Today(), -2),'MMM')&':'&
NUM(Sum({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating])
/
Count ({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating]),'##.00'))
Thanks for your reply but it does not solve my issue. I still get an error
Thank you Jwjackso,
I removed the column and I of the closing brackets and it worked. Below is the code
=date(AddMonths(Today(), -1),'MMM')&' '&
NUM(Sum({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating])
/
Count ({<[CusSat Date]={'>=$(=MonthStart(Today(), -1))<=$(=MonthEnd(Today(), -1))'}>} [CusSat Rating]),'##.00')
Thank you