0

Text indicator to show % change from previous period

I want my text indicator to show the % change from the previous period.

Ie. If the sales in 2024 were $100 and the sales in 2025 were $110, I want the text indicator to show 10%

8 replies

null
    • "making the sophisticated simple"
    • AviPerez
    • 2 wk ago
    • Reported - view

    Here are 3 techniques for YOY %. 

    • Technique 1 is not exactly what you wanted - but it's good to know.
    • Technique 2 is easiest.
    • Technique 3 is a little harder, yet more powerful.

    PS: For technique #2, use "Percent Difference Of..." not "Percent Of".

      • Ricky_Melamed
      • 2 wk ago
      • Reported - view

       Very helpful! thanks 

    • Ricky_Melamed
    • 12 days ago
    • Reported - view

    I've added a 2024YTD column into my report. When I use the YOY% it functions perfectly on all the other columns, but not the 2024YTD. For 2024YTD is just shows the value found in the 2024YTD column and not the YOY% from 2023. Is there a way to do this?

    For reference: https://community.pyramidanalytics.com/t/35yfsgw/add-a-column-that-shows-previous-year-ytd

    • "making the sophisticated simple"
    • AviPerez
    • 12 days ago
    • Reported - view

    It doesn't work because there is no "previous member" for 2024YTD in the semantic model. This is a custom member calculation. If you used the context calculations it would work, because it reads off the values from the report structure itself - that is, based on the context of where the calculation is run. (And BTW, what is the previous period for 2024 YTD ?)

    The best approach, if using track 3, is to add If/Then logic to your formula, that says, "If the current member is '2024 YTD', do this formula, otherwise to that formula". 

      • Ricky_Melamed
      • 12 days ago
      • Reported - view

       I suppose 2024YTD should show the YOY% of 2023YTD. I can see how this gets tricky.

      Though not perfect; is there a way to remove the indicator from the 2024YTD column? At least that way the data would be less visually confusing.

      • "making the sophisticated simple"
      • AviPerez
      • 12 days ago
      • Reported - view

       you can set indicators using a formula. Use the context menu to add conditional formatting to a single column. Once you see it working, you'll be able to figure out how to get closer to what you want use the "hasdatapoint" function.

      • Ricky_Melamed
      • 12 days ago
      • Reported - view

       Thanks - any chance you can show me an example? I've got no idea how to do what you're recommending.

      • VP Product Management
      • Ian_Macdonald
      • 11 days ago
      • Reported - view

       

      Have a read of this Help page and this page for an example.

      hope that helps.

      Ian

Content aside

  • Status Answered
  • 11 days agoLast active
  • 8Replies
  • 41Views
  • 3 Following