Reads as of next 5 days

[venkatg6759]

Hello ,

I have few publications which are published on each day. I have an expression to calculate the how many people read the publication after being published.

I need to find out how many people read the publication in first 5 days after it is published.

Expression for reads : sum(reads)

I created a variable for the next 5 days after being published and not sure how to calculate the reads for next 5 days after being published.

Any help on this

[eduardo_sommer]

You can create a flag field in your load script:

If((ReadDate-PublhisedDate)<=5, 'Y', 'N') as ReadInFirst5Days

Then in your expression, you can use

=count({$<ReadInFirst5Days={'Y'}>} ReadingID)

Eduardo

[venkatg6759]

There is no read date.There is just publication date .

[eduardo_sommer]

But how do you know when someone has read it, so that you can define if it was in the first 5 days or not?

[venkatg6759]

sorry there is a date called consumption date which shows when publication was read .

i tried this

if([Consumption Date]-[Publication Date]<=5,sum([Reads]))

this is giving me result when i include consumption date in the dimension .

Need help with aggr

i need to remove consumption date in the dimension and aggregate it.

[maxgro · Accepted solution]

maybe

sum(if([Consumption Date]-[Publication Date]<=5, Reads))