Forum Discussion

gsamaral77's avatar
gsamaral77
Helper I
4 years ago

Accumulated for a large data set

Hello, I hope everybody is okay

 

I need to create a Pareto chart that shows the equipment that fails the most

 

I know the steps to do that, creat de measure that count the fails, ranking, accumulated and % accumulated but the data set is very large, the equipment list has about 25000 lines so when a try to create de Pareto's chart show de error message that there is not enough memory. Someone can help me please?

 

Equipment's Table:

 

Note's table

 

They are connected by equipment's tag. The note's table contains the registers of fails.

 

Measures:

 

I believe the problem is filter All in the measure "Qtd de avarias acc", because return all the lines of the Equipment's table but I have no ideia how to fixe that's

 

 

 

 

 

 

 

1 Reply

  • You are on the right track.  To reduce cardinality you will want to group your data by equipment and then calculate the number of incidents.  Use SUMMARIZE or GROUPBY.