Hi Everyone,

I am building dashboard in PAW and I created calculated column for growth rate (current vs previous period). But once I change 'Period' Dim members calculated growth column disappears. Any idea how I can make so that calculated column stays and it updates accordingly once I change periods ..
For example, initially I set 2 periods 10-2020 & 10-2021 for comparison, and created Growth column. But once I change periods to for example 09-2020 & 09-2021 - annual growth column disappears.. Any help is appreciated. Please see visual below.. Thank you!



------------------------------
Aleksandre Metreveli
------------------------------

#PlanningAnalyticswithWatson

Once you synchronise a filter to either the rows or columns, it will overwrite what you have (in terms of MDX) with what you have selected in the filter.  Annoying, right?  

If you use picklist filters (using MDX in that subset to control what you see), you no longer need to synchronise the dimension and can achieve the above.

There is help online for how this can be achieved.  Let me know if you're unable to find and I'll attempt to dig something out.


------------------------------
James McCarthy
------------------------------

Original Message:
Sent: Wed November 02, 2022 02:49 PM
From: Aleksandre Metreveli
Subject: PAW Dashboard - Calculated Column - How to Keep it

Hi Everyone,

I am building dashboard in PAW and I created calculated column for growth rate (current vs previous period). But once I change 'Period' Dim members calculated growth column disappears. Any idea how I can make so that calculated column stays and it updates accordingly once I change periods ..
For example, initially I set 2 periods 10-2020 & 10-2021 for comparison, and created Growth column. But once I change periods to for example 09-2020 & 09-2021 - annual growth column disappears.. Any help is appreciated. Please see visual below.. Thank you!



------------------------------
Aleksandre Metreveli
------------------------------

#PlanningAnalyticswithWatson

Hi James,

Thank you for your response! Unfortunately I'm steal not quite clear on this. I read PAW Guide (file attached) starting from page 283 describing Picklists - is this what you are referring to?

------------------------------
Aleksandre Metreveli
------------------------------

Original Message:
Sent: Fri November 04, 2022 05:25 AM
From: James McCarthy
Subject: PAW Dashboard - Calculated Column - How to Keep it

Once you synchronise a filter to either the rows or columns, it will overwrite what you have (in terms of MDX) with what you have selected in the filter.  Annoying, right?  

If you use picklist filters (using MDX in that subset to control what you see), you no longer need to synchronise the dimension and can achieve the above.

There is help online for how this can be achieved.  Let me know if you're unable to find and I'll attempt to dig something out.


------------------------------
James McCarthy

Original Message:
Sent: Wed November 02, 2022 02:49 PM
From: Aleksandre Metreveli
Subject: PAW Dashboard - Calculated Column - How to Keep it

Hi Everyone,

I am building dashboard in PAW and I created calculated column for growth rate (current vs previous period). But once I change 'Period' Dim members calculated growth column disappears. Any idea how I can make so that calculated column stays and it updates accordingly once I change periods ..
For example, initially I set 2 periods 10-2020 & 10-2021 for comparison, and created Growth column. But once I change periods to for example 09-2020 & 09-2021 - annual growth column disappears.. Any help is appreciated. Please see visual below.. Thank you!



------------------------------
Aleksandre Metreveli
------------------------------

#PlanningAnalyticswithWatson

Hey,

This is the kind of thing I am referring to:

https://spitfire-analytics.com/resources/quick-tips-selection-widget-synchronization/

Rgds

James

------------------------------
James McCarthy
------------------------------

Original Message:
Sent: Sat November 05, 2022 02:52 PM
From: Aleksandre Metreveli
Subject: PAW Dashboard - Calculated Column - How to Keep it

Hi James,

Thank you for your response! Unfortunately I'm steal not quite clear on this. I read PAW Guide (file attached) starting from page 283 describing Picklists - is this what you are referring to?

------------------------------
Aleksandre Metreveli

Original Message:
Sent: Fri November 04, 2022 05:25 AM
From: James McCarthy
Subject: PAW Dashboard - Calculated Column - How to Keep it

Once you synchronise a filter to either the rows or columns, it will overwrite what you have (in terms of MDX) with what you have selected in the filter.  Annoying, right?  

If you use picklist filters (using MDX in that subset to control what you see), you no longer need to synchronise the dimension and can achieve the above.

There is help online for how this can be achieved.  Let me know if you're unable to find and I'll attempt to dig something out.


------------------------------
James McCarthy

Original Message:
Sent: Wed November 02, 2022 02:49 PM
From: Aleksandre Metreveli
Subject: PAW Dashboard - Calculated Column - How to Keep it

Hi Everyone,

I am building dashboard in PAW and I created calculated column for growth rate (current vs previous period). But once I change 'Period' Dim members calculated growth column disappears. Any idea how I can make so that calculated column stays and it updates accordingly once I change periods ..
For example, initially I set 2 periods 10-2020 & 10-2021 for comparison, and created Growth column. But once I change periods to for example 09-2020 & 09-2021 - annual growth column disappears.. Any help is appreciated. Please see visual below.. Thank you!



------------------------------
Aleksandre Metreveli
------------------------------

#PlanningAnalyticswithWatson