I'm new to Datameer and having a little trouble figuring out how to do something.
Say I start a workbook with a list of purchased items with item name and date of purchase.
In a new sheet I make a GROUPBY on the date in the first column and a GROUPCOUNT in the second column to have the count of purchased items per day.
So now I have a row for each day on which there was a purchase, what I need to do is to also have rows for days on which there was no purchase (with a 0 in the second column).
How would you do that ?
Please sign in to leave a comment.