I'm trying to develop a metric that shows the number of days of a customer's last purchase.
I tried to do it, for this way:SELECT max (Date (Data de saída da nota fiscal) - this)but this way, I need put in report, the attribute Date (Data de saída da nota fiscal) and not only a metric by customer name. If I don´t put the attribute, the report return error.
Thanks for help.
Best answer by Iva Gasparekova
Please feel free to check also this post below: