How to resolve issues with Period Over Period widget
Period Over Period (POP) widget is a powerful tool for comparing data across different time periods. However, there are certain limitations when using POP with drill down functionality in charts. This article will explain the issue and provide a recommendation for handling this situation.
Understanding POP Analysis
POP analysis helps to split dimension values into two parts based on the periods selected in the POP widget. This method is not suitable for splitting date values, as it can lead to irrelevant results. Therefore, using a date field in POP’s slave widgets is not recommended.
Consider the following example:
Data:
| Date | Dimension | Metrics |
|---|---|---|
| Jan-22 | X | 1 |
| Feb-22 | Y | 3 |
| Mar-22 | Z | 5 |
| Jan-23 | X | 2 |
| Feb-23 | Y | 5 |
| Mar-23 | Z | 7 |
Transformed for POP:
Recommendation
Then metrics column will be split into 2 measures as Metric P1 and Metric P2. if you use same date column in slave widget data will display like below. so, it is not recommended.
