Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
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))