How to Use Excluded Values from a Selection

hlines_usacs — Sat, 16 Nov 2024 20:53:43 GMT

Hello, I have a line chart with the dimensions and measure below. I also have 3 filters: Create Month, Create Week and Create Date.

Dimension: Service Month
Measure: SUM({<[Site Type]={'Yes'}>}Total_RVU)/Count({<[Site Type] = {'Yes'}>} DISTINCT Appointment_Id))

I was to add to the set analysis some logic that will use the excluded value selections from the Create Month, Week, and Date selections. For example, if I select January from the Create Month filter, I want my measure to reflect the excluded/alternative values of February, March, April, May, June, July, August, September, October, November, and December.

Any ideas on how to accomplish that by adding to the additional set analysis I have in the measure?

Thanks!

Re: How to Use Excluded Values from a Selection

jwjackso — Fri, 10 May 2019 18:27:27 GMT

I think you should use the E() function

try something like SUM({<[Service Month]=E(),[Site Type]={'Yes'}>}Total_RVU)/Count({<[Site Type] = {'Yes'}>} DISTINCT Appointment_Id))

topic How to Use Excluded Values from a Selection in App Development

How to Use Excluded Values from a Selection

Re: How to Use Excluded Values from a Selection