I am trying to create a column chart that captures the changes in payment terms from one term to another term. EX: first bar in the chart has a count of PO items that changed from 1064 > 1058 and so on…
Current the chart i have works fine and displays all the bars of different combinations of payment term FROM>TO.
Chart component filter: FILTER “_CEL_P2P_ACTIVITIES”.“ACTIVITY_EN” = ‘Change Payment Terms’;
Demension: “_CEL_P2P_ACTIVITIES”.“CHANGED_FROM”|| ’ > ’ ||"_CEL_P2P_ACTIVITIES".“CHANGED_TO”
i wanted to have two dropdowns that allows the users to pick a specfic payment from and specfic payment term to. I have added two button dropdowns (Change from payment term & Change to payment term) with the same component filter as above. However when trying use these dropdowns to filter the chart to only show a specific payment term from>to change, the chart is not updating and remains at showing all bars.
Dropdown1 formula: “_CEL_P2P_ACTIVITIES”.“CHANGED_FROM”
Dropdown2 formula: “_CEL_P2P_ACTIVITIES”.“CHANGED_TO”