Skip to main content
Question

Celonis cascading dropdown: bar chart doesn’t refresh when one of two dropdown changes

  • March 12, 2026
  • 0 replies
  • 4 views

kenjoeyamane
Level 1
Forum|alt.badge.img

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:

  1. Dropdown #1 (Date field): “Ordered Date” or “Submit Date”

  2. Dropdown #2 (Time interval): Days / Weeks / Months / Quarter / Years

  3. The Bar Chart buckets the selected date field by the selected interval.

Current logic / dependency chain:

  1. Dropdown #1 stores the selected date column PQL into: ai_purchase_analysis_histogram_dd
  2. Dropdown #2 is a dependent control: It uses ${ai_purchase_analysis_histogram_dd.pql} for its data. It stores the PQL into: graphtimeinterval
  3. Bar chart dimension uses: ${graphtimeinterval.pql}

The issue

The chart updates when:

  1. I change Dropdown #1 then Dropdown #2
  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.