How do I calculate %

Tue, 01 Nov 2011 04:50:40 GMT

I have the following data

UserID country Region, SerialNo MonthYY

U1 USA, Americas C12 022011

U2 CANADA Americas C34 032011

U2 CANADA Americas C34 052011

U3 INDIA Asia C45 022011

U1 USA Americas C12 032011

U4 UK Europe C67 052011

U5 Italy Europe C55 032011

U6 Singapore Asia C56 062011

I have created another barchart with Dimension: Region, Expression: Count (Distinct UserID)

This displays Number of Units in every Region as per below.

Now I want to dispaly in %. i.e %of Users in every region. How do I enter expression?

Thanks

Re: How do I calculate %

Tue, 01 Nov 2011 05:06:19 GMT

in the expressions tab, tick the "Relative" option.

I cant upload any images at the moment, so hope this helps

Tue, 01 Nov 2011 05:15:39 GMT

Hi Andrew

Thanks. I tried as follows

Count (DISTINCT UserID)/ Count( TOTAL DISTINCT UserID)

your suggestion relative works. It is simple and easy.

Thanks for the quick help. Appreciate.