The number of articles whose average viewership is higher after modification

[marioxp]

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?

[dplr-rn · Accepted solution]

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 .