cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EC_1
Helper III
Helper III

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
eka24
Super User III
Super User III

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

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

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

eka24
Super User III
Super User III

Please try this:

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

Didn't work
The Chart will not display anything 

eka24
Super User III
Super User III

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.

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"

eka24
Super User III
Super User III

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

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

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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (51,827)