Stock Market type up and down arrown icons

Hi,

I have designed a report that gives me the server utilization trend of last 7 days for a particular server on date wise . Now i want to show using an up or down arrow facing top and bottom based on the values of the previous day.

eg:

if yest utilization is 75 and todays utilization is 80 then a and upword arrow should show next 80

Some thing similar to stock market like report

Any suggestion how to go about.

Thanks in Advance.

Regards
Praveen

Find more posts tagged with

Comments

mwilliams

Hi Praveen,

Would something similar to the following screenshot work for what you're wanting to do? Let me know.

tcskurra

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi Praveen, 
 
Would something similar to the following screenshot work for what you're wanting to do? Let me know.</blockquote>
 
Hi Micheal, 
 
Thats exactly what i am looking for in my case only the first column will change which will show date 
 
It will of great help if you can share the logic with me.. 
 
Thanks in advance 
 
Praveen

mwilliams

Praveen,

Yeah, I figured you'd use date. I just took the easy road of copying and pasting the S1 thing in the flat file

. The report design is attached along with the flat file and arrow pics. The report was made in BIRT 2.3.

tcskurra

<blockquote class='ipsBlockquote' data-author="mwilliams">Praveen, 
 
Yeah, I figured you'd use date. I just took the easy road of copying and pasting the S1 thing in the flat file

. The report design is attached along with the flat file and arrow pics. The report was made in BIRT 2.3.</blockquote>
 
 
Hi Micheal, 
 
Thank you very much for giving me the Idea about how to go with 
 
but i got stuck at one place. 
 
The example that you have given me works perfect but when i try using it. In my case,data sets is a query from db (db2) which joins 2 tables and provides me the out put. When i tried this logic on one of the column called AVG_DISK_IO with computed column called AVG_IO_DIFF with the same expression that you had applied for computed column in the example I am getting the error that I am attaching the screen shot of that 
Hence i am stuck here now 
Any suggestions 
 
 
Regards 
Praveen

mwilliams

Praveen,

Can you attach your report design so I can look at it. Obviously I won't be able to run it without your data, but I can check out everything else.

tcskurra

<blockquote class='ipsBlockquote' data-author="mwilliams">Praveen, 
 
Can you attach your report design so I can look at it. Obviously I won't be able to run it without your data, but I can check out everything else.</blockquote>
 
Hi, 
 
I have attached the report design and the sample html out put. there are 3 datasets i have applied your logic on beacon 2 and beacon3 datset with new computed column.

Regards 
Praveen

mwilliams

Praveen,

Looking at your report design, I notice that you're not setting the variable i to 0. So, when it's checking for i==0, it doesn't know what you're talking about. You need to put i=0; in the initialize method of the report. This should do it.

tcskurra

<blockquote class='ipsBlockquote' data-author="mwilliams">Praveen, 
 
Looking at your report design, I notice that you're not setting the variable i to 0. So, when it's checking for i==0, it doesn't know what you're talking about. You need to put i=0; in the initialize method of the report. This should do it.</blockquote>
 
Micheal, 
 
It worked perfectly, but if you saw my sample out put in the last attachment 
i have 3 different data sets for 3 different servers. and trying to show 
DISK IO, MEM Util,DISK Util for the 3 servers for last 6 days. 
 
As per you logic i used a new computed column called AVG_IO_DIFF and used the steps that you have suggested it worked perfectly. But when i added another computed column called AVG_MEM_DIFF,AVG_CPU_DIFF and tried the same logic the new computed column that should show the difference is showing some wrong values. 
if i apply it only for one column either CPU or DISK it work fine but when i apply for more than 1 columns for the same data set the whole thing is getting wrong. 
 
I am attaching the report design and also sample screen shot. Not able to figure out why its happening.. 
 
Is this only possible with one column or am i doing wrong some where. i also used a different variable instead of i and checked but not luck. 
 
Thanks in advance for all the support. 
 
Regards 
Praveen

mwilliams

Praveen-

You're most likely getting variable mixing because you're using the same variable names in all the computed columns. What you should try is setting 3 variable (i,j, and k) to 0 in the initialize method of the report, then use a different one of those for each computed columns. Also, you should change the names of the "last" and "change" variables in each computed column to like last/change, last2/change2, and last3/change3. This should fix your problems that you're getting. Give it a try and let me know.

tcskurra

<blockquote class='ipsBlockquote' data-author="mwilliams">Praveen- 
 
You're most likely getting variable mixing because you're using the same variable names in all the computed columns. What you should try is setting 3 variable (i,j, and k) to 0 in the initialize method of the report, then use a different one of those for each computed columns. Also, you should change the names of the "last" and "change" variables in each computed column to like last/change, last2/change2, and last3/change3. This should fix your problems that you're getting. Give it a try and let me know.</blockquote>
 
Hi Micheal, 
 
Sorry for the delayed respose. It worked perfectley. 
 
I just followd the steps that you suggested. 
 
Thank you very much... 
 
Regards 
Praveen