# Calculations & Trellis chart in Visual Intelligence(Lumira)

For doing Calculations in Visual Intelligence, just follow the simple steps below.

1. Create a simple chart, With time measure on y axis and few months on x axis (line/Bar preferably)

2. In the y axis measures you will see a drop down, click on it – > add calculation ->

3 Simple Steps for Calculating Moving Average in Visual Intelligence

(refer the above link for these two steps)

**RUNNING SUM:**

First column remains the same, from the second column the running addition starts,

i.e, the second column gives the addition of 1st and 2nd column(of actual data).

As the running SUM cant be on the same axis as of the actual data(as scale differences are there), it has been dragged to Y axis 2 here.

SHOW LEGEND : Right click on the header part and click on “show legend”. Similar procedure can be followed to show data labels.

**RUNNING MINIMUM & MAXIMUM:**

*RUNNING MINIMUM* – First column remains the same, from the second column the comparison is made with the running columns and the minimum value till that column is taken.

i.e, the second column(minimum) returns the minimum value from 1st and 2nd column, the third column(minimum) returns the minimum value from 1st 2nd and 3rd column.

*RUNNING MAXIMUM – *First column remains the same, from the second column the comparison is made with the running columns and the minimum value till that column is taken.

i.e, the second column(maximum) returns the maximum value from 1st and 2nd column, the third column(maximum) returns the maximum value from 1st 2nd and 3rd column.

**RUNNING COUNT & RUNNING COUNT (EMPTY EXCLUDED):**

*RUNNING COUNT* – This function is used to keep the count of the number of columns.

*RUNNING COUNT (EMPTY EXCLUDED) – *Similar to the *RUNNING COUNT*, just that zero values are excluded.

**RUNNING AVERAGE & PERCENTAGE:**

*RUNNING AVERAGE* – First column remains the same, from the second column the running average starts,

i.e, the second column gives the average of 1st and 2nd column(of actual data).

*RUNNING AVERAGE (EMPTY EXCLUDED)* – Similar to the

*RUNNING*, just that zero values are excluded.

*AVERAGE**PERCENTAGE** – *Each column value is divided by the total sum and multiplied by 100, just as we calculate the normal percentage.

**RANK:**

Below “add calculation” , “Rank values” function is available.

Columns are sorted in descending/ascending order (as per the selection made, Top/Bottom). On “month” gives the sorted order for each month,whereas On “all” gives the common sorted order.

This rank value can be edited as shown below, click on the same down arrow, and edit.

**FORECAST & LINEAR REGRESSION IN CHARTS:**

Forecast calculation is well explained by Tammy Powlas and Frank Rambo in the links below.

*LINEAR REGRESSION* – As soon as this option is clicked , the pop up showing “extrapolation Length” will appear. In which user has to enter the “extrapolation Length” in months (here)

And linear regression is calculated on actual data.

**TRELLIS CHART:**

When 2 or more measures are there, and the scaling/viewing information becomes difficult ,for ease of use this chart is used.

Click on the down arrow(shown in the 1st image right below , this arrow(marked one) is located at the end of “measures”) .

Legend color ll have the column names as shown in 2nd image below.

Drag the “data” which is in “legend color” to “columns by”.

Here is how the output looks like.

I hope this provides an overview of the calculations done in SAP VI (Lumira).

Thanks,

Sara

Good Explanation !!

Thank you Om Prakash.

Hi Sara,

I am new in SAP Visual Intelligence.

This is a good document to understand but can you please tell me, on which data source you built this visualization??.....Excel, BI 4, MSSQL, Oracle etc.??

Hi,

Thank you. I used MS Excel as a data source here.

Happy learning! Do let me know if you need any further clarifications.

Regards,

Sara

Hi Sara,

Really helpful document for starters.

Thank you Nirupa. ðŸ™‚

Do check the other similar DOC. Lumira For Beginners .

Nice Document Sara ... Thanks for sharing

Thank You Durgamadhab

Glad to know its useful.

Regards,

Sara

Well explained..great work Sara G

Thank You Farid Hasan

BR,

Sara

Really Nice Documents... thanks for sharing the Doc...

Gr8 job...

Cheers ðŸ™‚

KP

Hi Sara,

Good Day!

Nice analysis! I appreciate.

Keep sharing new things. Have a nice day!

Regards,

Hari Suseelan