I have created a metric. Based on current date it will fetch the current month.
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/0c908f73-b374-4362-b213-552261d1248e.png)
I have another metric for defining Historical period. I am trying to drive this by above grid.
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/912917bf-3813-47a5-84e4-9aa4bb2ec23a.png)
However I am getting an error while applying the formula.
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/259b2d0e-b35b-4db4-869b-30753c460252.png)
What is that I am missing or doing wrong. Please suggest the right logic
Best answer by Thu Mai
View original