Sign In

Welcome Back,

Signup/Login with your account

Don't have account,

You must login to ask a question.

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

Lumenore Community Latest Questions

  • 0
akgupta@netlink.com
akgupta@netlink.comBeginner
Asked: February 10, 2026

Hello Team, I am working with a dataset that contains transactional data with a date column (for example, Order_Date) and business metrics such as Sales. Sample scenario: Order_Date: 2023-01-15, 2023-02-10, 2024-01-20 Metric: Sales Amount Use case:I want to analyze: Month-over-Month (MOM): Comparison of sales for ...Read more

Hello Team,

I am working with a dataset that contains transactional data with a date column (for example, Order_Date) and business metrics such as Sales.

Sample scenario:

  • Order_Date: 2023-01-15, 2023-02-10, 2024-01-20

  • Metric: Sales Amount

Use case:
I want to analyze:

  • Month-over-Month (MOM): Comparison of sales for Feb-2023 vs Jan-2023

  • Year-over-Year (YOY): Comparison of sales for Jan-2024 vs Jan-2023

While the date field is already present in the dataset, I would like to understand how YOY and MOM requirements should be framed correctly in Lumenore, especially in terms of:

  • Using date hierarchies (Year / Month)

  • Choosing between dataset-level vs dashboard-level calculations

  • Handling scenarios such as partial months or missing dates

Could you please share the recommended approach or best practice for defining YOY and MOM analysis in this context?

Read less