Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts I need to get a bar chart that shows average Month on month Customer satisfaction ratings from the month of April 2018 to April 2019. That is, the average customer satisfaction rating for each month. Below is the code I but it does not give the expected results. What I get is May 2018 to May 2019. Your help will be greatly appreciated.
Thanks.
Sum({<[Date]={">=$(=QuarterStart(Today(),-1)) <=$(=QuarterEnd(Today(),-1))"}>}[CusSat Rating])/
Count({<[Date]={">=$(=QuarterStart(Today(),-1)) <=$(=QuarterEnd(Today(),-1))"}>}[CusSat Rating])
@Pomna Are you using QlikView or Sense? I would like to move this into the correct product forum.
yes
@Pomna I am sorry, is it Qlik View or is it Qlik Sense you are using.
qlik sense