Data calculation

Posted by Yaara Magen

Posted on Mon, 10/25/2010 - 08:56 in MashZone

Hi,

I have a data feed as follows:

I want to show the % of relevant names from each domain, and i want to be able to filter it by domain.

for example: in domain A 25% of the names are relevant.

How can i do this?

Thanks,

Yaara

23.5k

by Jim Thompson

Posted on Tue, 10/26/2010 - 00:23

Have you looked at using a Pivot Table in Excel?

by Yaara Magen Author

Posted on Tue, 10/26/2010 - 08:57

Hi,

A pivot table is a nice idea, but i want my mashup to work using simple reports which will run automatically once a day without any intervention (like inserting a pivot table into them).

thanks

by Stephan Freudl

Posted on Wed, 10/27/2010 - 12:15

Hi Yaara,

of course MashZone can help you, you don't need to go the Excel Pivot way. What you basically need is counting data rows after filtering according to your "is relevant?" column. Most has been asked (and answered) by Roy before. If you need further help, just drop message.

Regards

Stephan

Data calculation

Featured achievement

Leaderboard

Follow us

View posts by tag