Forum Discussion

charlie_torres's avatar
charlie_torres
Frequent Visitor
3 years ago
Solved

Create a Matrix with Filtered Column Items based on a dynamic date range.

Dear @community, On the need for help again :[ after reading about many similar situations in the forum, but not quite the intended solution. The current problem is creating a matrix that follows a ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi charlie_torres,

    I'd like to suggest you use measure formula to instead the value field to use on matrix.

    You can use this formula to lookup raw table records and add a variable to extract the current row context date to use in compare with system date steps.

    After these steps, you can use an if statement to check current row context data to prevent the calculation in the not match ranges and move the corresponding expression into the if statements true branch.
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi charlie_torres,

I'd like to suggest you use measure formula to instead the value field to use on matrix.

You can use this formula to lookup raw table records and add a variable to extract the current row context date to use in compare with system date steps.

After these steps, you can use an if statement to check current row context data to prevent the calculation in the not match ranges and move the corresponding expression into the if statements true branch.
Regards,

Xiaoxin Sheng

charlie_torres's avatar
charlie_torres
Frequent Visitor
3 years ago

Hi Anonymous 

 

That was it. It is fully working as expected.

Thank you very much

Regards
Charlie