Skip to main content

Hi guys,

10.2 question. I am trying to calculate a gini coefficient. You can learn more about it here: Gini coefficient - Wikipedia

 

There was a prior post about it here: null

 

Aaron's answer from the prior quesiton is giving me a 0 at each mark. I think this is due to each mark in my graph being its own partition (because each ID's Amount is summed across multiple rows of the data source). I really don't need a per-mark value, just the value for the entire graph.

 

Conceptually, I want twice the sum of the differences of each point from a slope=1 line.

 

If we can do it without displaying the underlying inverted Lorenz, that is fine.

Gini Coefficient

Thanks in advance for any wizardry.

6 answers
  1. Sep 28, 2017, 9:38 PM

    Hi Ray,

        From Aaron's comment you dimension ID is sorted in descending order.  Should it not be sorted in Ascending order by the amount?

     

    Hi Ray, From Aaron's comment you dimension ID is sorted in descending order. Should it not be sorted in Ascending order by the amount?

     

    Then after that edit gini table compute using needs to be set to use ID.

     

    pastedImage_0.png

     

    I think that's what you're looking for.

     

    Regards,

    Gerardo

0/9000