how can i set intervals for the x-axis

i need to set intervals for x-axis in a chart, i must order the number of persons that there are in 0-10 ages, 10-20 ages, etc.

Find more posts tagged with

Comments

mwilliams

Hi cheli,

One way would be that you could create a computed column in your dataSet that outputs the range that the current row falls into. Then, you could use this value as your x-axis category.

cheli

Thanks you very much Mwilliams

your answer has been very helpfull ^^

cheli

i thougth that i could be solve my problem with your answer, but i have been trying and i dont know how i have to do exactly. please you can put an example ?

mwilliams

cheli,

Can you post a small csv file of what your data looks like that I can use to create a quick example? Also, let me know your BIRT version, so I can make the example in your version.

cheli

sorry , but i dont know how i can do that , i can post an image of the chart that i get with all the ages without intervals and the number of persons in each age in the y-axis.

cheli

i found the way for make le file .CVS

mwilliams

cheli,

I'm not sure I understand the data in the .txt file you attached. I'm going to guess your data is something like the following. Let me know if this is right or wrong and I'll try to make an example.

Age | NumVisitors
1 | 3
2 | 5
3 | 5
4 | 4
5 | 6
6 | 2
7 | 14
8 | 22
9 | 15
10 | 20
11 | 30
12 | 33
13 | 27
14 | 26
15 | 29
16 | 13
17 | 10
18 | 4
19 | 3
20 | 4
21 | 2
22 | 3
23 | 6
24 | 7
25 | 7
26 | 6
27 | 8
28 | 6
29 | 10
30 | 9
etc...

cheli

sorry for dont give you a better explain, it is exactly how you have told. Age / NumVisitors

mwilliams

cheli,

Check out this design. You can see the computed column to make the category for the chart. You'll need to remove the .txt extension from the csv file to make it work. Also, you'll need to change the path to the csv file in the dataSource in the report design.

cheli

thank your very much,
Your answer solved my problem ^^

mwilliams

Glad to help!