cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Duplicated Values in PieChart

I want t show the values with the highest downtime , but the pie chart is showing duplicated values
hoy can i group them or show no duplicated

10 REPLIES 10
Highlighted
Community Champion
Community Champion

Re: Duplicated Values in PieChart

You can add Distinct or Group By to your Collection. Can you show your formula for the community to help

Highlighted
Helper II
Helper II

Re: Duplicated Values in PieChart

Filter('[dbo].[Stopwords]',Linea="D2",'Tiempo de Reparacion'>=10)

I'm using my SQL Table where all the information is send

Highlighted
Community Champion
Community Champion

Re: Duplicated Values in PieChart

Please try this:

Distinct(Filter('[dbo].[Stopwords]',Linea="D2",'Tiempo de Reparacion'>=10),Linea)

Highlighted
Helper II
Helper II

Re: Duplicated Values in PieChart

Didn't work
The Chart will not display anything 

Highlighted
Community Champion
Community Champion

Re: Duplicated Values in PieChart

Since there are duplicates which may also have corresponding duplicated figures on the column 'Tiempo de Reparacion', i suggest we group the Linea column. That is only one name per Linea, then all figures are also put together for 'Tiempo de Reparacion'. this is the formula:

1. AddColumns(
GroupBy('[dbo].[Stopwords]',"Linea","SumTiempo"),
"Totals", Sum(SumTiempo,'Tiempo de Reparacion'))

2. If you want to filter Linea then:
Filter(AddColumns(
GroupBy('[dbo].[Stopwords]',"Linea","SumTiempo"),
"Totals", Sum(SumTiempo,'Tiempo de Reparacion')),Linea="D2")

If you want to filter 'Tiempo de Reparacion' (Total) then:
Filter(AddColumns(
GroupBy('[dbo].[Stopwords]',"Linea","SumTiempo"),
"Totals", Sum(SumTiempo,'Tiempo de Reparacion')),Linea="D2",Totals>=10)
 

If you like this reply, please give kudos. And if this solves your problem,
please accept this reply as the solution.

Highlighted
Helper II
Helper II

Re: Duplicated Values in PieChart

Let me explain it better

I have a Table call "stopwords" in that table i have several columns

Like "Line" , "Tiempo_de_reparacion" , "Tipo de Falla"

what i want is that the PieChart shows the "Tipos de Falla" filtered by "Tiempo de reparacion >= 10" and Line
I use this formula and it works fine BUT I don't want to see duplicates


Filter('[dbo].[Stopwords]',Linea="D2",'Tiempo de Reparacion' >= 10)
In the Labels i have "Tipo de Falla" and Series "Tiempo d Reparacion"

Highlighted
Community Champion
Community Champion

Re: Duplicated Values in PieChart

Do the items with duplicates also have corresponding figures in the column Tiempo_de_reparacion ?
If so, when you remove the duplicate, do you want the corresponding figures to be deleted or added?
You are now introducing Tipo de Falla" but I can't see it in your formula that is working

Waiting for feedback

Highlighted
Helper II
Helper II

Re: Duplicated Values in PieChart

Capture.PNG
That is the table 
As you can se I have the column "Tipo de Falla" and on the Left there is "Tiempo de Rep"
and I have more records and The value "Electrica" from Tipo de Falla appears several times
what i want is that all those value get grouped and displays only 1 record for each like

Tipo de Falla Electrica there is 4 records the sum of the Tiempo de Rep = 21 min
Tipo de Falla Set up there is 1 record the sum of the Tiempo de Rep = 6 min
Tipo de Falla Neumatica there is 1 record the sum of the Tiempo de Rep = 2 min
and so on

Highlighted
Helper II
Helper II

Re: Duplicated Values in PieChart

Capture.PNG
and here is the PieChart Formula, Labels and Series

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (10,376)