Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to count how many articles have exceeded the average number of views after the update compared to the data before the update
The data we have is:
1. Impression data
2.Article information
In the case of the table itself, I have no problem to show if we have more views.
if((avg({<date={">=$(=Min(MA_R4_B5_post_modified))"}>}
MA_R4_B5_pageviews)))>=avg({<MA_R4_B5_date={"<=$(Max(MA_R4_B5_post_modified))"}>} MA_R4_B5_pageviews),1,0)
But I have a problem with doing just a count of articles that have increased viewership after modification, I don't need a list of articles
Can you help me somehow?
I would say it would be easier and better performance to create a flag in the table indicating if a view is before or after modification.
then your chart expression before simpler .
I would say it would be easier and better performance to create a flag in the table indicating if a view is before or after modification.
then your chart expression before simpler .