Hi Community,
I have a requirement. I am trying to figure out using groupby , addcolumns but unable to achieve what i need.
I have a table like below with user and candy. I want to create a new gallery where the users information is stored along with the no of candy allowed. (So if for example Antony occurs more than 3 times , then the Maximum column should be 3, if its less than 3 , then no issue)
Datasource/Table
Expected table into a Gallery
@Anonymous
Set the Items property of your Gallery to:
AddColumns(GroupBy(yourDataSource, "User", "_recs"), "_maximum", CountRows(_recs))
Set a label in the Gallery to ThisItem.User and another to ThisItem._maximum
I hope this is helpful for you.
Thanks for helping.
Actually using that query gives me the sum however what i am looking for is a if condition. if the users (e.g Antony) has the candy count of more than 3 times then the Table/Gallery should have Antony in Users and 3 in Maximum.
if the count is less than 3, then we leave the count as it is.
@Anonymous
I'm not exactly understanding that logic. If the candy count is a count of the records for that user, are you saying if it is more than 3 that it should just show 3, and if less than 3, should be the count?
User | Count |
---|---|
256 | |
107 | |
90 | |
51 | |
44 |