How do Flash Charts deal with null values?

Hi everyone,

I have many null values in my data. Obviously the flash charts operating on this data have a lot of problems.
Does anyone know how flash charts generally deal with null values?? I have a many indexing problems which dont appear with "0" values instead of "null" in the data.

regards

work_ph

Find more posts tagged with

Comments

mwilliams

Hi work_ph,

Can you show a small sample of your data and explain more about what you're getting as an output? Possibly a screenshot or two? Thanks.

work_ph

Hi michael,

thanks for your response. I attached an exel file which should be helpful to illustrate my problem.

I have three different flash pie charts in which I need the same color for the same category. If there is no data availabe I want to hide the corresponding category.

I reached that by putting "null" in my data instead of "0" in BIRT.
So viewing the flash pie charts works fine this way. But the interactivity of the chart doesn't. If I click on a pie slice the parameter is wrong and it opens a different slice.
I think this is an index problem caused by the null values in the data.
The pie charts show the right series, have the right values but the clicking leads to wrong results. I tried to fix this with a workaround but I couldnt figure out the way how those flash charts (I have the same problem in a bar chart) deal with null values.

Do you have any idea how to solve that problem?
Thanks in advance!

work_ph

mwilliams

work_ph,

Can you create a simple report with a flat file dataSource with a sample of your data so that I can work with the report and do some testing? Thanks.

work_ph

Hi Michael,

i created an example of my problem.

In the report you can click on the pie chart slices to show the details in the table on the right.
The data file contains three different States in the order
1. Alabama
2. Alaska
3. Arizona

If in a pie chart the value is null, regarding the color it is considered anyway. so in the end the right color is assigned. But internally the null value state is deleted and the index for the later link is wrong.

If you click on the "Arizona" slice in the "High" pie you are led to "Alaska" in the detail table although the drill-through link is set correctly. (Because Alaska is missing in this pie)

Simply click through the example and you will see it.

Is there a possibility to work around this issue? For example to script the indexing and make the links correct?

Thanks for all your efforts

Kind regards

work_ph

PS: the flat file is csv and is attached in the zip file. You have to adapt the source in the datasource

mwilliams

work_ph,

Currently, there is no scripting on flash charts in Actuate BIRT. I believe there will be in the Actuate 11 release later this year. Scripting in A11 would allow you to custom set the colors so that you could filter out the null values to avoid any indexing issues. I'll keep looking at the example you gave me to see if I can find a way around the null value issue. I'll let you know if I find anything.