Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Calculation of Change in a Table

laetizia_w
Level 5
Level 5

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

I have such table:

forum.png

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

1 Accepted Solution
ursboller
Correct answer by
Community Advisor
Community Advisor

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 solution in original post

1 Reply
ursboller
Correct answer by
Community Advisor
Community Advisor

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 solution in original post