Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a survey table with have Caller Name. I want to calculate How many names appear 1 time , How many appear 2 times How many appear 3 times, how many appear 4 times and so on. I need number and % both as measure and No. of times i.e 1, 2, 3, .... as dimension. Please help. Thanks
Try that:
Script Source Example:
Answers:
LOAD * INLINE [
Answers
One
One
One
Two
Two
Three
Three
Three
Three
Four
Four
Five
Five
Five
Five
Six
Six
Six
Six
];
Chart:
Dimension: Answer
Expression 1: count(Answers)
Expression 2: count(Answers) >> SET RELATIVE OPTION
With Dimension of "Caller Name", an expression of "Count([Caller Name])" will provide the count for each caller.
To create the dimension as count, use the calculated dimension of:
=Aggr(count([Caller Name]), [Caller Name])
-Rob
Thanks Rob. Its great.