Add columns ; groupby

[PPSA]

Hi,

I'm playing around with charts and data manipulation, trying to get better at it.

Formula below is my attempt so far to group my source data by date, then I want to add a column which will be a count of how many items are in each grouped table.

It's the expression for the count I'm struggling with.

Hope that makes sense

ClearCollect(datamanip,AddColumns(GroupBy(colCOntainerInfo,"Contnr_booked","DATA"),"TotalToday",CountIf(colCOntainerInfo,Contnr_booked=Contnr_booked)))

Thanks

[RandyHayes · Accepted solution]

@PPSA 

First: 

ClearCollect(datamanip,    
    AddColumns(
        GroupBy(
            colCOntainerInfo,
            "Contnr_booked",
            "DATA"
        ),
        "TotalToday",CountRows(DATA)
    )
)

Although I do not know your data or what is in each of these, I am going by the description that you said you have Grouped by date, so I am assuming that Contnr_booked is that grouping. 

If so, then there is no filter and count as the DATA element will have all the records associated with that date.  Just use the CountRows and you will have your value.

I hope this is helpful for you.

[PPSA]

Perfect @RandyHayes .

Think I was over thinking it, had previously used countrows but was trying with something before DATA.

Thank you.