I'm tracking utilization statistics for my hospital. I've figured out all of the calculations to accomplish this (see 'Bed Day Utilization' x Month Dashboard); however, when I try to consolidate the visualization into a bar chart (please see 'Bed Utilization x Month' worksheet), the calculations in the view don't match. I'm aware that there can be some rounding issues when using the AGGR function; however, I'm not sure if this is the case or if I'm just not doing something correctly. Packaged workbook is attached.
Thank you in advance for your help.
답변 2개
Hi, when I removed filters in each bar in the Dashboard the value matched so I'd suggest to review the calculation logic of filters.
