How to build - KPI function with varying start dates, term lengths, and repeating?

jakesachs · 2025-02-27T00:31:41+00:00

There was an error rendering this rich post.

We'd like to do something but I am not sure how to do it or if it is possible. Basically creating a KPI system for employees where managers can create KPIs for employees that are 3/6/9 months in length, start at any given month, and then continually repeat.

So if John has a KPI start in March of 2025 that is for 3 months, it should be from March-May, then again from June-Aug, Sept-Nov, Dec-Feb 26, etc. We need to be able to create a KPI starting in any month, any employee, for either 3/6/9 period repeating.

Any help in how this could be built or if it is possible would be great.

I was thinking maybe the KPI needs to be a child list of the employee rather than a list itself, because if it is its own list there would be a lot of sparsity in a module that has both the employee list and KPI list.

Accepted answers

All comments

SriNitya

Create Employee list and KPI lists as two different lists.
Create a module dimensioned by Employee and KPI lists (expecting that Employee to KPI relation is 1: many) and then ask user to input start date and duration of months then derive end date from duration for the KPI's.
Hope it helps.

devrathahuja

Hi @jakesachs ,
If there is minimal overlap between the KPIs of different employees then it makes sense to have it as a child of the employee, otherwise it'd be better to have it as 2 separate lists.

You could then create a module with start date & duration which will be used in your tracking module.

The tracking module would be time dimensioned where you can filter out the views for each employee depending on the KPI durations.

In this case you'd see John & all the KPIs relevant to him for Mar-May, but when you select another employee say Jake, who has a 6m KPI with same start date, you'd see Mar-Aug for him.

Hope this helps! :)

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…