Hello All,
I work in the healthcare field and created a dashboard that shows metrics like volume, revenue and others. We want to give each Provider access to this dashboard so they can see their own metrics. I created a RLS for each provider to filter the data on the name of the specific Provider. The issue I am having is we also want the dashboard to show the Max, Mean and Median for each of the metrics shown, across all providers. We want to use this as to tool to show the Providers how they are performing vs. other. When I created the RLS for a provider all of the metrics, including the Max, Mean and Median update to only show that provider (meaning the Max, Mean and Median are equal to the exact value of that specific provider). Is there a workaround for this so the Max, Median and Mean values still show for all of the providers, but the actual metric for that provider logged in only shows for them specifically?
Thanks, Kory
