6 Replies Latest reply: Jul 4, 2016 11:18 PM by ARINDAM DUTTA RSS

    last seven days data in line chart

      Hi every one i have a expression which gives me the percentage of the active customers of the total customers.I want to visualize the same for last seven days.Can any one help me what to add to the expression to make that possible.The Expression is given below.


      (Count({$<Date={'>=$(=Date(Max(Date)-30))'},Country=P(Country),ClientStatus={0}>}distinct ClientNumber))/(Sum({$<ClientStatus = {0}>} Aggr(RangeSum(Above(Count({1<Country=p(Country)>} Distinct Reg_ClientNumber),0,RowNo())),DataWeekNo)))