Options

# How to calculate the difference between every two years and k-means clustering question.

Hi,

Currently this is my data view

In the result, first, i need to get the difference between revenue-expenses between every two years (2018-2017; 2017-2016..)

The result I get must be in percentage

May I know how to do this? I have tried using generate attribute, date diff also didnt work

Besides that, this is my k-means clustering results

Although the result is correct already, but my lecturer ask me to convert the result into percentage form?

Does anyone can help? Thanks in advance and I'm really appreciate your help.

Currently this is my data view

In the result, first, i need to get the difference between revenue-expenses between every two years (2018-2017; 2017-2016..)

The result I get must be in percentage

May I know how to do this? I have tried using generate attribute, date diff also didnt work

Besides that, this is my k-means clustering results

Although the result is correct already, but my lecturer ask me to convert the result into percentage form?

Does anyone can help? Thanks in advance and I'm really appreciate your help.

Tagged:

0

## Answers

1,635UnicornTo do this correctly, you need to enclose the name of the attributes in square brackets. So your expression would be something like this:

"2018_percent_change" = ([2018.0]-[2017.0])/[2017.0]

There are obviously several ways to calculate percentage changes so you have decide on the appropriate denominator.

If you have a lot of these attributes to define, instead of doing it manually, you could also use a loop and macros to create them all for you automatically.

Lindon Ventures

Data Science Consulting from Certified RapidMiner Experts