Flash Map Questions

Hi All,

I created a US flash map report using the tutorial found here: http://www.birt-exchange.org/org/devshare/designing-birt-reports/1360-birt-flash-map-example/

I have a few questions about customizing my results:

1) I enabled the includeValueInLabels in my dataXML string, and added a label separator using labelSepChar. Is there any way to specify a carriage return as the label separator?

2) Is there any way to code the colorRanges so that each of the 3 ranges dynamically updates? I'd like to update the ranges based on what the average is each month, which may change over time.

Find more posts tagged with

Comments

mwilliams

Can you make an example with the sample database or with another type of data that I can run, so I can see what all you've done and then we can work with the same file.

lgudait

Thanks for your reply. I've attached a mock up based on the tutorial I previously mentioned.
The changes:
- I updated the SQL to include product code, and added a filter so that the same report can run for different product codes
- I added includeValueInLabels='1' labelSepChar=': ' to the xml (labelSepChar is where I'm curious as to if you can specify a carriage return somehow)
- Changed showLabels='1' from '0'
- Changed the field ranges to be more in line with the revised SQL
I'm most interested in knowing if there's a way to designate the field ranges based on the average customertotal for each product code (like make the below range equal to 0 to Average-100, middle range average-99 to average + 100, top range average+101 and above)

lgudait

Attachment - I tried to post this earlier, and it kept failing, and upping my upload quota

mwilliams

The upload failing was the zip? Or just the .rptdesign and then you zipped it? Let me know.

As for breaking in the label, using a separator of '\n' should do that. I'll take a look at the range thing, right now.

lgudait

I was getting an error trying to reply to your post earlier in the day. It's fixed now.

Edited to add - The error happened regardless of whether I included the attachment to the post. My upload quota and the website seem to be working fine now.

mwilliams

Good to hear! Here is an updated example showing the dynamic ranges, along with the line break in the label.

lgudait

This looks great! I see how the text element connects the variables to data set in the onCreate script.

Many Thanks!

mwilliams

You're welcome!

Since you have a table bound to the dataSet already, you should be able to move the script from the text box to the onCreate of your table row, where you populate your data variable. I just used a separate text to be able to display the values.

lgudait

So I have modified the report to work with my actual data set, and it works great.

One of the things I did that some others may find helpful was to add a table with the values for all locations not on the map (such as Puerto Rico and the Virgin Islands). I added conditional formatting that matches the color coding on the map using the report variables.

mwilliams

Great! Thanks for the update! A simple example showing this solution would be a good devShare entry, if you have the time to post one. You'd also be entered in the devShare contest:

http://www.birt-exchange.org/org/wiki/index.php?title=DevShare_Contributor_of_the_Month_Contest