Time related Question

saurabh_kumar_kunwar
saurabh_kumar_kunwar
in Academy Discussions

Hi Experts,

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

Screenshot 2023-07-19 152830.png

Thanks in advance

Best Answer

  • Konstantin97
    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?

    Thanks,
    Kostya

Categories