Group by date and summarize number of pages
I have a table that records each book read, the user, number of pages read and the date. I have used
As you can see on
summarize for displaying the total number of pages read and also used ->defaultGroup to group by month and year. This looks great, but the summarize result is not correct.As you can see on
Date: Dec 2020 the sum of pages shows 243, which is not correct.