Forum Discussion
Solved
Top 80% Engagement
Hi guys, I have a table with Item ID and Engagement. Now i would like to create another table that shows which items that make up 80% of total engagements, also these items should desc by engagement...
ive never done this before but maybe this will work
engagementmeasure = sum(engagment)
incrementalengagement =
VAR CurrentEngagement = Table[engagementmeasure]
RETURN
SUMX (
FILTER ( table, table[engagementmeasure] >= incrementalengagement ),
table[enagementmeasure]
)Table[IncrementPCT] =
DIVIDE (table[incrementalengagement],
sum (engagementmeasure))
then based on that result theoretically you can create a table where the Table[IncrementPCT] <= 0.8
This is a great idea! Thank you!