Forum Discussion
Solved
Calculate mode from a data table
Nice day. I have a historical data table with which I have calculated the average and median but I lack fashion. I've been searching different forums and haven't found the solution. I would be ve...
You just can remove the column I have put in measure, than the output is correct
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
As a complement to the help I require, it is like having a table with the following data:
| Nationality | Age |
| Mexico | 25 |
| Mexico | 15 |
| Mexico | 30 |
| Mexico | 30 |
| Mexico | 20 |
| Colombia | 22 |
| Colombia | 35 |
| Colombia | 40 |
| Colombia | 40 |
| Colombia | 50 |
| Argentina | 18 |
| Argentina | 21 |
| Argentina | 45 |
| Argentina | 45 |
| Argentina | 33 |
| Canada | 16 |
| Canada | 22 |
| Canada | 28 |
| Canada | 28 |
| Canada | 34 |
And that as a result the following summary table:
| Nationality | Fashion (age) |
| Mexico | 30 |
| Colombia | 40 |
| Argentina | 45 |
| Canada | 28 |