1 Reply Latest reply on Nov 27, 2018 5:52 PM by Jennifer VonHagel

Calculate Min and Max Value excluding one Area and applying all filters

Ritu Chandiramani Nov 27, 2018 4:58 PM

Hello,

I need to calculate the Min and Max values for one of the calculated field in the attached packaged workbook. Please refer to sheet HI_Patient_Day Rate Sheet

The Min and Max values will be based on the following conditions:

It should exclude MJR_AREA_NM = 'SCR_OOA' while calculating the value.

It to take into account any changes to the filters on the right while calculating the value.

Any guidance will be helpful.

Best Regards,

Ritu Chandiramani

CoC_Dashboard_v10.3_Ritu.twbx 4.8 MB

1. Re: Calculate Min and Max Value excluding one Area and applying all filters

Jennifer VonHagel Nov 27, 2018 5:52 PM (in response to Ritu Chandiramani)

Hi Ritu, your workbook is trying to connect to your live data source. Can you check that it your data source is using the Extract and re-attach it?

Thanks,
Jennifer
Like Show 0 Likes(0)

Actions

Tableau Community Forums

Calculate Min and Max Value excluding one Area and applying all filters

1. Re: Calculate Min and Max Value excluding one Area and applying all filters

Actions

More Like This