I'm new to using Canvas and have set up a KPI card to capture daily sales data. The information for the current value pulls through ok and I've used an expression for the day dimension to default to yesterday
When pulling through a comparison value for the same day last year I’ve written the following expression as the Data Point. The formula works when posted in a worksheet. When I tested it originally it worked but it seems to have stopped. Any idea what I’m doing wrong?
Could this be a solution?
=TEXT(TODAY()-366,"yy-MM-dd")
Thanks for the response. This works but doesn't allow me to link the data point dynamically to the original selection.
NOW RESOLVED
Use PALO.DATA instead of PALO.DATAC
Join the Jedox4Beginners forum and engage with a community of passionate Jedox users. Get expert advice, share insights, and find solutions to your Jedox-related queries. Unlock the power of collaboration and accelerate your learning journey in the world of Jedox.
