There is a product limitation right now which does not expose the summary metric in the Reports. However here are two approaches you could consider,
(1)Please check once if you could use monthly granularity, then the sum up of individual rows(months) will be closer to the summary metric. The current CSV Exports only export data at monthly, weekly, daily, hourly granularity.The higher the granularity the lesser the error.
Having said that, this is still not the most accurate mechanism to derive this metric.
Its documented here https://community.khoros.com/t5/Community-Analytics/Community-Analytics-metric-definitions/ta-p/109853
(2) Other than that, we also expose the raw data via Bulk Data API which can be used to get accurate counts of the same metrics.
Please let us know if either of these two approaches would work.
... View more