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

# 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)))

• ###### Re: last seven days data in line chart

Where you trying to do this? Can you provide some context or a sample?

• ###### Re: last seven days data in line chart

i am trying to make a line chart which will reflect the total number of active customers of the total number of registered members.And I want to show this for last seven days result in a single linechart

• ###### Re: last seven days data in line chart

Hi Arindam,

Create variables to replicate the below two things MaxDATE and MaxDATE-6

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

• ###### Re: last seven days data in line chart

Then you need add a calculated dimension a below

=if(Date>= maxdate-6 or date<=maxdate, Date)

And then Check Suppress when value is null

• ###### Re: last seven days data in line chart

Hi Arindam,

Have you found the solution you were looking for? or can you post a sample ?

• ###### Re: last seven days data in line chart

hi Vineeth

No I have not found the solution yet .I think since I have already added date once in the set analysis I am not able to use it again to visualise the last seven days