Sign In

Welcome Back,

Signup/Login with your account

Don't have account,

You must login to ask a question.

You must login to add post.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Leave An Answer!
  • 0
ashutoshjoshi4545
Beginner
Asked: 2026-02-11T11:15:59+05:30

How to implement a dynamic Monthly/Weekly toggle with derived KPI logic?

We are building a dashboard where:

  • Users can toggle between Monthly and Weekly views

  • KPIs like “Done Sooner” and “Delayed” must dynamically recalculate

  • Date logic is based on forecast snapshot vs actual date

Challenge:

When switching between week and month:

  • Aggregation changes

  • Forecast alignment logic changes

  • Snapshot selection needs to remain consistent

Is there a recommended way in Lumenore to:

  1. Build a date dimension supporting both week and month aggregation?

  2. Use a single KPI logic that adapts dynamically?

0 Answers

Leave an answer

You must login to add an answer.