Forum Discussion
Create a Matrix with Filtered Column Items based on a dynamic date range.
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
Hi Anonymous,
Your suggestion is exactly what I was looking for. It's starting to look accordingly. However, The only obstacle I am finding now is filtering what the matrix displays based on the dynamic range of dates I created. Therefore, this is only shown if a date associated with a building is within range.
Any idea how I can accomplish this?
Many Thanks
Charlie
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
Hi Anonymous
That was it. It is fully working as expected.
Thank you very much
Regards
Charlie