I have a requirement where three properties DuedaysEvent1, DuedaysEvent2 and DuedaysEvent3 of a case holds number of due days for different events like Event1, Event2 and Event3 respectively. We need to display a chart for Event1, Event2 and Event3 (stack) based on the Due days properties for events and these Event1, Event2 and Event3 are not properties to configure as columns. Due days for each events in X-axis as buckets like <0 as Overdue, 0 as Due today and >0 as Days remaining and on Y-axis the Case ID counts and this will be the aggregate column and Event types in stack (Series). On click of each event drill down to that specific cases based on the due days bucket.
Create a report definition that first calculates a derived “Due Bucket” value for each event property using a when or declare expression that maps values to Overdue (<0), Due Today (0), and Remaining (>0). Then expose three rows per case by using a data transform or declare index that flattens Event1, Event2, and Event3 into a common structure with fields like EventType and DueBucket. Build the report on this flattened data so DueBucket becomes the X-axis, count of Case IDs becomes the Y-axis, and EventType is used as the stacked series. Configure the chart in the dashboard using this report definition. Finally, enable drill-down by passing the EventType and DueBucket as parameters to open a filtered case list report.