Calculation of Change in a Table | Community
Skip to main content
laetizia_w
Level 4
Mar 29, 2019 8:40 AM UTC
Solved

Calculation of Change in a Table

I am having a question maybe someone could help me out.

I have such table:

And I would like to see es coulums the value of last month, two month ago and the Change. Plus maybe our Goal value. Does anyone know how to get all this in one freeform because I have no idea how to do so with the Goal and the Change

I hope someone has a great Idea

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Urs_Boller
Urs_BollerAccepted solution
New Participant
Mar 29, 2019 2:13 PM UTC

you can insert date ranges "last month" and "2 month ago" as columns and you get the raw numbers. everything else is not easy to do, might be best done in excel with report builder.

however, if you are looking for a fany way and don't mind a lot of work, have a look in my blog post I wrote about the solution: https://perfectdashboard.rocks/kpi-summary-table/

View reply

1 reply

Urs_Boller
Urs_BollerAccepted solution
New Participant
Mar 29, 2019 2:13 PM UTC

you can insert date ranges "last month" and "2 month ago" as columns and you get the raw numbers. everything else is not easy to do, might be best done in excel with report builder.

however, if you are looking for a fany way and don't mind a lot of work, have a look in my blog post I wrote about the solution: https://perfectdashboard.rocks/kpi-summary-table/

Translate
Terms & ConditionsAccessibility statement

Loading footer...