cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Column charts with distinct function

Hello!

I have a column chart inside of my application.

I have added my database to it but I can't figure out how to get what I want. 

My database is named 'Manco-Informatie' and I will use 2 columns in there, Product, Aantal. I want to use the function distinct on the product to get the duplicates out of the way. Aantal means number. I basically want to add up the numbers for each product and then show it inside of the column chart. So you can see how many times a product has been chosen. I hope I explained this clear enough.

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

On the Items of the Chart, put:

AddColumns(GroupBy('Manco-Informatie',"Product","SumColumn"),"TotalAantal",Sum(SumColumn,Aantal))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

4 REPLIES 4
eka24
Super User
Super User

On the Items of the Chart, put:

AddColumns(GroupBy('Manco-Informatie',"Product","SumColumn"),"TotalAantal",Sum(SumColumn,Aantal))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Anonymous
Not applicable

Thank you for your answer! @eka24 

This seem to not add up the numbers, I still get it shown like this: 
https://gyazo.com/45625235ff754bfb0d7f892856287ff0
https://gyazo.com/41cedd36da330fe7dca26ba19df366b7

Out of nowhere it works, thanks!

Can you give a similar screenshot or a sample of your table

chart.JPG

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Anonymous
Not applicable

It all works now, just had to reload it or something. Thanks!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,143)