I am trying to filter by the current month in each of the metrics, I would use TODAY() function in excel, but since there is no function like that on Pigment.
As a workaround I created a metric that I called Current Date (Month Dimension) , which I will update monthly, so that I can filter by that metric and automatically update all the other metrics.
IF('MRR Be Churn Analysis'=1,TRUE)[FILTER:'Data Hub'::Month='Current Date']
However, I did not work, do you have any suggestion or guidance?
Thank you very much in advance!
Best answer by BenoitView original