Jump to content
Changes to the Jaspersoft community edition download ×

group elements that count < than 10% of total


2005 IR Help

Recommended Posts

By: ToRaX - torax

group elements that count < than 10% of total

2005-04-04 00:35

I hope someone can help me with this issue...

 

I use the following query: select v_client as client, count(v_client) as total from t_xyz group by v_client order by count(v_client) desc

 

This query creates groups for the different clients and additionally gives me the number of occurences of each client.

 

This is working well, but the problem is that there are quite a lot of clients with about 3% or less and I would like to put them together under the name "rest", because the resulting piechart looks very ugly.

 

Can I do this with SQL or iReport?

I'm very thankful for any suggestions!

 

 

 

 

By: ToRaX - torax

RE: group elements that count < than 10% of total

2005-04-06 06:57

No ideas?

Any suggestions would be very helpful to me...

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...