Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
There is no read date.There is just publication date .
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?
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.
maybe
sum(if([Consumption Date]-[Publication Date]<=5, Reads))