Forum Discussion
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
- lbendlinSuper User
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.