I have a calendar heat map that displays a measure of operating room (OR) efficiency over a 12 month period. This heat map was created by scaffolding the underlying data set to a table of all calendar days, so a full calendar is presented even if no data was present. Without filters, data is presented as expected showing all calendar days even if no data is presented. The ask is to provide a dynamic dimension filter (in this case a group of surgeons), so the calendar heat map would be restricted to this particular group. When adding this dimension filter to the dashboard, days without data disappear. I assume that this behavior is related to the order of operations, where the filter is applied to the data set after the scaffolding, filtering out the days without data.
How can this filter be applied to the underlying data set BEFORE the join to the scaffold, so days without data is also displayed on the heat map?
Hi @Ronald Kahn how did you get on with this in the end? If one of the above answers helped it'd be great if you could select as "best". That closes off the thread, helps people searching in future, and gives people like Jim some points/kudos for their efforts. Alternatively if you ended up doing something different it's always good to post back as that will also help people searching in the future. Ta v much, Steve.
