I’m encountering a refresh/dependency issue with a cascading dropdown setup in Celonis Studio.
I have a bar chart histogram where the user selects:
-
Dropdown #1 (Date field): “Ordered Date” or “Submit Date”
-
Dropdown #2 (Time interval): Days / Weeks / Months / Quarter / Years
-
The Bar Chart buckets the selected date field by the selected interval.
Current logic / dependency chain:
- Dropdown #1 stores the selected date column PQL into: ai_purchase_analysis_histogram_dd
- Dropdown #2 is a dependent control: It uses ${ai_purchase_analysis_histogram_dd.pql} for its data. It stores the PQL into: graphtimeinterval
- Bar chart dimension uses: ${graphtimeinterval.pql}
The issue
The chart updates when:
- I change Dropdown #1 then Dropdown #2
- I chagne dropdown 2 only
But the chart does NOT update when:
I change Dropdown #1 only (Ordered Date ↔ Submit Date)
So it seems the chart only refreshes when graphtimeinterval changes, not when the upstream dropdown (ai_purchase_analysis_histogram_dd) changes, even though Dropdown #2 references it.