last seven days data in line chart

[#1]

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

[sunny_talwar]

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

[#3]

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

[vinieme12]

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

[vinieme12]

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

[vinieme12]

Hi Arindam,

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

[#7]

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