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
Jitendra Mishra
Beginner
Asked: 2024-11-21T11:10:42+05:30

How I can do YOY of measure using Self-service

I have my shop data, in which I record my daily sales from the past 5 years. Now, I want to know the YOY, MOM, and DOD sales changes. How I can do this in the Lumenore?

advance analysisyoy
1 Answer

Leave an answer

You must login to add an answer.

1 Answer

Voted Oldest Recent
  1. Beginner

    Hello Jitendra,

    Kindly use the below formula to do a YOY analysis,

    Formula:

    (SUM(<Numerical Column>) – LAG(SUM(<Numerical Column>)) OVER (ORDER BY SUM(<Numerical Column>)) / NULLIFZERO(LAG(SUM(<Numerical Column>)) OVER (ORDER BY SUM(<Numerical Column>)))

    • 0