Eclipse Community Forums: BIRT » Count in Chart, TopN

Help

Home

Home » Archived » BIRT » Count in Chart, TopN

Show: Today's Messages :: Show Polls :: Message Navigator

Count in Chart, TopN [message #480168]

Fri, 14 August 2009 08:50

Evgeny

Messages: 19
Registered: July 2009

Junior Member

Hello and thank you for reading this post,

I am new to Birt and have just started building a report.

My goal is to display topN customers. And my table is looking like this:

Customer A
Customer B
Customer A
Customer A
Customer C
Customer C
Customer A

What I succeeded so far is to create a report which shows me the amount of
the orders of the customers, it looks like this:

Customer A - 4
Customer C - 2
Customer B - 1

I have done that by having a Count function in the Summary Field of the
Data Cube and a Sum function in the field on the Cross Tab.

And here my problem:
I would like to create a Chart, which shows me my top N customers. So in
this case a pie chart, where i have A with 4/7, C with 2/7 and B with 1/7.
How can I do that with the given dataset? The summary field with the count
function is returning one for each value and thus it is not possible to
have the desired chart with that.

Any help is greatly appreciated.

Evgeny

Report message to a moderator

Re: Count in Chart, TopN [message #480212 is a reply to message #480168]

Fri, 14 August 2009 12:06

Evgeny

Messages: 19
Registered: July 2009

Junior Member

ok, thanks for reading. I just saw the "Show as chart" option, however I
dont know how to get the topN customers, since it is not possible to edit
the chart Filters... I will start a new thread for that.

Report message to a moderator

Re: Count in Chart, TopN [message #480265 is a reply to message #480212]

Fri, 14 August 2009 15:22

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Are you using a table or crosstab? Switch the view back from the chart
view (tab at bottom of item) add your filter and then switch back to
chart view.

Evgeny wrote:
> ok, thanks for reading. I just saw the "Show as chart" option, however I
> dont know how to get the topN customers, since it is not possible to
> edit the chart Filters... I will start a new thread for that.
>

Report message to a moderator

Previous Topic:	Sort a column and get the top N of the column
Next Topic:	Customization of Gantt chart

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 23 01:58:13 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter