Time related Question


Hi Experts,

I have a custom dimension on Week I want to use the data from previous Week Suggest me the solution

Thanks in advance

Best Answer

  • Konstantin97
    Answer ✓

    Hi @saurabh_kumar_kunwar!

    One of the possible solutions would be a reference to previous week via lookup.

    Let's say you crated line item "Previous week" in "TECH - weeks" module.

    Then you can write a formula X=Y[lookup: 'TECH - weeks'.Previous week]. But you can't refer to the same line item since it's gonna be circular reference.

    Also you may consider using CUMULATE().

    If none of these solution helps, can you describe the details of the problem you're trying to solve?