How can I display % change against last year's week in Dynamic Textbox?

caiopimenta Member

November 2022 in Charting

Hello everyone,

I am trying to create a little bit of dashboard storytelling and show the % change from week X in 2022 against week X in 2021.

I am looking to do that inside the dynamic textbox. Is that possible?

Thank you so much

0

Best Answer

• 

  GrantSmith Coach

  November 2022 Answer ✓

  Here's a more detailed writeup of how to configure a date dimension dataset which will go over how to set up everything and allow you to do simple YoY or PoP % calculations.

  
  

  https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

  **Was this post helpful? Click Agree or Like below**
  **Did this solve your problem? Accept it as a solution!**

  0

Answers

• 

  GrantSmith Coach

  November 2022

  You’d need to calculate it in a beast mode and then use that value in the text

  **Was this post helpful? Click Agree or Like below**
  **Did this solve your problem? Accept it as a solution!**

  0
• 

  caiopimenta Member

  November 2022

  Thank you for the answer. Very helpful.

  Can you give me an example of how this calculation would look like inside beast mode?

  0
• 

  GrantSmith Coach

  November 2022 Answer ✓

  Here's a more detailed writeup of how to configure a date dimension dataset which will go over how to set up everything and allow you to do simple YoY or PoP % calculations.

  
  

  https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

  **Was this post helpful? Click Agree or Like below**
  **Did this solve your problem? Accept it as a solution!**

  0
• 

  caiopimenta Member

  November 2022

  Thank you so much!!

  0