using an athena dataset, every day i download the situation of the total form views of my cta hubspots.
with periodOverPeriodDifference I can thus have the daily trend of the form views and not just the cumulative
my problem is that if I put everything in the table, the total does not come out as in the image
how can i solve? I would like to see 40.293 in daily form views total
Unfortunately this might be a limitation of the calculation on the Total with a custom calculation like Period Over period. If the total is an important metric i would recommend removing from pivot and adding as a KPI below or above the pivot.
We are working on improving the totals! Please feel free to Direct Message with more information about your use case and i can add to our customer feedback for this feature.