Hi to all the community, been using metabase in my company for some time now and I am totally amazed about how flexible metabase is as a reporting tool.
Lately I am working on a price table for several commodities. Almost each day the prices are downloaded over the internet and stored in this table. For each date I have one price per commodity.
Now what I want to do is to use the latest date price for each commodity in order to run some calculations, but I can't seem to find a way to make the appropriate filter in the date field. I could use the today filter and bring the today's prices, but some times some commodities do not update for a day or two so that would break the calculation.
Thank in advance for anyone who will help..