cancel
Showing results for 
Search instead for 
Did you mean: 

how to use mean median mode in Paxata?

Highlighted
Blue LED
To create a new project using the median to find the middle number 
Labels (1)
0 Kudos
1 Reply
Highlighted
Blue LED
Hi @Viji ,
To do this, you'll need to have a common value across the rows in which Paxata can "Group" the rows by. So giving a very simple example where you have a single column of values, you'd use a "computed column" to add a "constant" value. In my case, i have added the letter "a":

Image: https://us.v-cdn.net/6030933/uploads/editor/b4/h50ajeub6fdv.png

Once you have this, use the "Shape" to "Group By" as below (i am showing here two different calculations here average/mean and median:
Image: https://us.v-cdn.net/6030933/uploads/editor/9t/4v9jfpqe3y6t.png


0 Kudos