Grouping Dates or Pulling Dates from a List

Community Discussions
, ,
1

Is it possible to Filter a Table so that a column of multiple repeating dates would only show the date once? I probably FUBAR'd that explanation, so example for say an expense tracker:

Table 1
08/01/2022 $10
08/01/2022 $10
08/02/2022 $20
08/03/2022 $20
08/03/2022 $20
08/03/2022 $10

I would want Table 2 to pulled the dates and add the totals:
Table 2
08/01/2022 $20
08/02/2022 $20
08/03/2022 $50

I have an idea how to do the calculation of the totals in the second column, but cant figure a way to group the dates.

3

Hi @Bria-8687 ,

Thank you for your post and welcome to the community!

Yes, here are some articles explaining how to do this-
Filter()
Filters in Honeycode

If you would like to review this in more detail, we are holding office hours. You can sign up for office hours here.

I hope this helps! Please let us know if you have any questions.

Thank you,
Evelyn