KPI Card Formula Pr...
 
Notifications
Clear all

[Solved] KPI Card Formula Problem

3 Posts
2 Users
1 Likes
144 Views
Jedox 4 Beginners
Trusted Member Admin
Joined: 3 years ago
Posts: 32
Topic starter  

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?

 

 


   
Quote
Topic Tags
Jedox 4 Beginners
Trusted Member Admin
Joined: 3 years ago
Posts: 32
Topic starter  

Could this be a solution?

=TEXT(TODAY()-366,"yy-MM-dd")


   
ReplyQuote
New Member
Joined: 7 months ago
Posts: 1
 

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


   
ReplyQuote
Share:

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.

Join the Jedox4Beginners forum!