0

is there a way to calculate an mesure avarage for the last year from yestrday?

I want to calculate a moving avarege of a mesure that will be always take the period of a year from yesterday or preveious week back.

can someone help me with this calculation?

3 replies

null
    • Customer Solutions Architect
    • Moshe_Yossef
    • 1 mth ago
    • Reported - view

    Hi 

    What is your data source? Is this an OLAP cube or a Pyramid Model? (As I recall it is OLAP - correct me if I'm wrong).

    Do you have a hierarchy that is just date or do you use a date hierarchy?

    Can you add a screenshot of your data?

    Thank you

    • VP Product Management
    • Ian_Macdonald
    • 12 days ago
    • Reported - view

    Hi 

    The answer to your question depends on the data source you are using. To give you best answer, we need to know if it is an MDX based source (Microsoft Analysis Services (OLAP or tabular) or SAP BW) or a Pyramid model on a SQL database.

    If you can provide the information, we can give you the most accurate answer.

    Thanks,

    Ian

    • VP Product Management
    • Ian_Macdonald
    • 2 days ago
    • Reported - view

    Marking as answered as no response from poster.

Login to reply

Content aside

  • Status Answered
  • 2 days agoLast active
  • 3Replies
  • 37Views
  • 3 Following