Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Stockmarket format table reports
Migrateduser
<p>Hi all, I'm very new to BIRT reports and came via SpagoBI. I'm a DBA with a bit of programming understanding, but I believe I am now out of my depth.</p><p> </p><p>I have a table that displays rows of data of visitors to a website. Its the usually type of data;</p><pre class="_prettyXprint _lang-nocode">+
+|DATE | NO_VISITORS | PAGES_VIEWED | BANDWIDTH_USED | PEAK_HOUR|+
|
|
|
|
||2014-04-04 | 350100 | 100400 | 85 | 2140 ||2014-01-03 | 300100 | 510000 | 125 | 2140 ||2014-01-02 | 120000 | 450000 | 87 | 2230 ||2014-01-01 | 200000 | 650000 | 78 | 2030 |+====================================================================+</pre><p>I would like to mimic an Excel spreadsheet that uses Conditional Formatting rules and arrow icons, but I would settle for changing the background colour of each cell to one of three colours: red for decrease, green for increase and blue for no change.</p><p> </p><p>As for the data, the latest figures always appear at the top, so the data from the top line is compared only with the data from the previous day i.e. so the 4th Jan is compared with the 3rd Jan, the 3rd Jan with the 2nd Jan, etc.</p><p> </p><p>I have been googling for over a week now and picked up a lot but I suspect this will require Java or Javascript, having already investigate using Highlights. Highlights was useful for alternating background colours for each row, however, if I missed something do feel free to point it our to me.</p>
Find more posts tagged with
Comments
There are no comments yet