cancel
Showing results for 
Search instead for 
Did you mean: 

Trend calculation

Former Member
0 Kudos

Is there in xMii possible to gat trend info from 30 days data? I need only information if trend is '+', '-' or '=' ?

Is this some java script or should be oracle calculation?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Roman,

You can able see the trends for last 30 days by selecting date ranges.

In chart you have to adjust Ticks per Label,Major ticks,Minor Ticks on the axis tab,Scaling types,chart width to get the full visibility.

Here the code looks like this:

document.Trend.getQueryObject().setEndDate(enddate);
document.Trend.getQueryObject().setStartDate(startdate);
document.Trend.updateChart(true);

But you have mentioned some conditions + or - , can you elaborate on this.

-Suresh Hiremath

Edited by: Jeremy Good on Jun 20, 2009 10:23 AM

Changed from refresh() to updateChart(true) so that the query dates will not update to current time (time based query).

Former Member
0 Kudos

Yes, I would like to get only information if data in last 30 days are in positive or negative trend.

Like you have on stock market - arrow up or down.

So calculation should tell me if KPI is expected in rising mode or in drop mode

I would like to create screen like

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b03f3298-7758-2a10-86a2-f1c14319b748]

on page 9 Line speed!

Former Member
0 Kudos

Roman,

Yes, you can develop similar dashboard of up and down arrow.

For this you need to create BLS transaction. It can be archived as described below:

1) Get SVG object of Arrow. Load it in Dynamic Graphics Editor,define object properties like color.In animation links map this property with fill parameter of the arrow and save this file as .sva

2) I hope you have Parameter details in some database. Make query on that

3) In transaction call that query using SQL Query action block.

4) Use Repeater Action and configure it by SQL output(Rowsets/Rowset/Row).

5) Add conditional or switch action block o check the value is +,- or =

6) Add Animated object Render for each condition and map Color property with needed color code like"#ff0000"

7) Add Image Saver action and save it in your server drive.

😎 In JavaScript load these Images by giving the "src" tag.

Hope this helps you.

-Suresh

Former Member
0 Kudos

Thanks for this answer, and will be helpful.

My problem is how to calculated from data which I have in table if this up or down trend?

Like:

______________

1.1.2009 90

1.2.2009 93

1.3.2009 92

1.4.2009 95

1.5.2009 92

1.6.2009 91

1.7.2009 99

Now I would like to calculate if this trend is up or down. Is there a way to calculate this in java or xmll or even oracle?

I think should be like SLOPE or LINES formula(this is from excel)

Former Member
0 Kudos

Look at the Linear Regression action under Misc. Functions.

Former Member
0 Kudos

thx

.....and one not connected question

I found free pie cart on net and is work fine, but....how to enter parameters on line in applet?

this is applet

<APPLET CODE="Pie3D.class" WIDTH=500 HEIGHT=300>

<PARAM name="title" value="Demo Pie Chart">
<PARAM name="aspect_fudge" value="1.5">
<PARAM name="transparency" value=".8">

<PARAM name="show_values_on_slices">
<PARAM name="show_percents_on_legend">
<PARAM name="show_legend_on_right">

<PARAM name="val_1" value="5">
<PARAM name="description_1" value="item1">

<PARAM name="val_2" value= "33">
<PARAM name="description_2" value="item2">

<PARAM name="val_3" value="80">
<PARAM name="description_3" value="descr1">

<PARAM name="val_4" value="10">
<PARAM name="description_4" value="descr1">

</APPLET>

is this possible?