Forum Discussion

Regular Visitor

8 years ago

Calculate

Para gerar uma medida da estatística de mode (número que mais se repete) utilizo a dica de Marco Russo em (site Marco Russo). Até aí tudo bem ! Agora os meus dados tem duas colunas: Uma com os at...

Solution Sage

8 years ago

Hi scavalcantes,

Sorry but I don't know Portuguese.

Could you please also make an English version description about your requirement if possible?

Thanks,
Xi Jin.

scavalcantes
Regular Visitor
8 years ago
Follow the English version using google translator

To generate a measure of the statistics of mode (number that most repeats) I use the tip of Marco Russo in (site Marco Russo). So far so good!
Now my data has two columns:
One with the attributes, coming from the conversion of columns into rows (pivot) and the other with the values corresponding to the attributes.
How do I filter the attribute so that the corresponding value displays the mode inside a card?
It would be perfect if we could display all the most repeated values!
Note:
1- See that the attached image is doubled item double 120, ie any item with double text, needs to display in fashion on the "blank" card.
2- I also attached the files to facilitate the understanding of the doubt and sending the tip !! The following link is from the files: Files to download

_______________________________________________

In the image it has the following terms:
Slicer: Column and Crush
Composition: double
CodQualidade: double ...
Em branco: In blank
Displaying the Values of the Value Column. Not be correct as it should also be blank.