nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create a pie chart with 4 variables as source

Steven Jung

Hey Birt Communtiy, 

I hope my english is not so bad.
 
My problem:
 
I have a datas with with an Id. This Id show me the state of a maschine (on, off, stanby, service).
I add the time from every state to certain variable.
Now I need to represent this 4 Variables in a pie chart.
My first idea is to build a two-dimesional array (one for legend and one for the values) or two arrays.
How could i give my 4 variables to the pie chart. Pls dont link me to other forum post, because i looked for so many solutions but nothing work.
 
My question: what could i do to say the pie chart that i want to represent this 4 variables (so i wont select something from data set, i want use this 4 variables; its not possible in birt to select them in series i think)
 
 
Would be really nice if someone could help me.
 
I cant upload a rptdesign, so if you need this to understand my problem, maybe u give me your email.
 
 
 
Greetings
Steven

Find more posts tagged with

Comments

Clement Wong

Sorry, I don't understand the part where you describe how your data is retrieved and how it is represented. What does your data look like? Can you attach a CSV of sample values?
 
Also, maybe a mockup screenshot or drawing of what you would like the final output to look like?
 
What version of BIRT are you using? Commercial, or open source BIRT?

Steven Jung

Okay the data is retrieved from other software.
 
I want to know how i could represent 4 Variables in a pie chart, thats all.
 
Maybe i discribed it bad, but i just wanna represent this 4 variables. In pie chart i just could select datasets and no variables.
 
 
Hope u could help and Thank You for your answer.

Clement Wong

Can you please share some sample data?
 
I'm guessing here... so your actual data might look like the following?
<pre class="_prettyXprint">
ID Date

1 01-01-2016
1 02-05-2016
...
2 01-05-2016
2 02-14-2016
...
3 01-02-2016
...
4 01-24-2016
...</pre>

And then you have a ID-State table?
<pre class="_prettyXprint _lang-">
ID State

1 On
2 Off
3 Standby
4 Service
</pre>
And your (aggregated) data might look like the following?
<pre class="_prettyXprint">
State Total

On 10
Off 20
Standby 30
Service 40</pre>
Then, you want a pie chart of the different states and their totals?
 
If not, sample data would be helpful to understand your scenario.

Steven Jung

Hey Clement Wong this is nice that u take time for it.
 
Yes u are right.
 
And your (aggregated) data might look like the following?
State Total

On 10 Off 20 Standby 30 Service 40
Then, you want a pie chart of the different states and their totals?
 
If not, sample data would be helpful to understand your scenario.

i have this 4 variables and want it to represent in a pie chart. how is this possible.
Thanks for ur help.
 
Grettings Steven

Clement Wong

You would just create two Data Sets for your CSVs: one for your detailed data, and the other for your ID-State table.
 
Then, create a New Joint Data Set that would join the detailed data with your lookup table.
 
Next, create a chart report element as a Pie Chart. Under the Select Data tab, for Category Definition, choose the "State" column. For Slice Size Definition, choose the "Date Event" column. You'll need to change the Function to "Count".

Steven Jung

Thank you, I try this but im not the best in Birt

Is it possible to do this in a other way?
Because I have to handle few other thinks in my report and I dont know how many it influence my other tables.
 
 
Have a nice day.
 
Steven

Clement Wong

Having a Joint Data Set would be independent of your other report items.
 
And if you're data source is not CSV, and is from a relational database, you can do your joins in the database instead.