gopy6243's avatar
gopy6243
Advocate IV
9 months ago

Lorenz Curve

IN this post I demonstrate how to plot Lorenz Curve using VC

IMPORTANT NOTE:  you will need to "sort by ascending sales and compute the cumulative %"  in M query , then drag this  cumulative % ( and name it LorenzX) to the viusal instead of dragging product name or id , this is mandatory since the scale should be from 0 to 100%

example :

example result:

 

"When the bottom 40% of products are included, they contribute about 21.4% of total sales."

"Overall sales inequality is low inequality (Gini = 0.27)."

 

BY Hadi Kheireddine

No RepliesBe the first to reply