Announcements
Hello everyone,
I have created a chart which accesses a sharepoint list and shows me all entries in a monthly overview, with the following code on the item property. Now I want this monthly overview to show all entries that have the property "yes" from the column "quality".( its a Yes/No column)
AddColumns(GroupBy(AddColumns(List;"Month";Text(End;"[$-en-US]mmmm-yy"));"Month";"Grouped");"Count";CountRows(Grouped))
@Dens47 In that case your formular would look like this
AddColumns(GroupBy(AddColumns(Filter(List;quality.Value = "Yes");"Month";Text(End;"[$-en-US]mmmm-yy"));"Month";"Grouped");"Count";CountRows(Grouped))
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @PowerRanger ,
thank you for your quick answer. Unfortunaly it doesnt work. Do you have an idea?
@Dens47 try it with a capital V
So Qualität.Value and not Qualität.value
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 354 Super User 2026 Season 2
M Bilal Khan 320
Mohsin Ali 246
