9 Replies Latest reply on Dec 5, 2016 11:49 AM by Norbert Maijoor

# Rotation Maximum to be detailed by Modality

Hi everyone,

In attached twbx file i have created measure to retrieve average, minimum and maximum for the Rotation. Each Rotation will have different number of Radiologists scheduled (Report Finalized By is the name of the dimension)  who works different days(Report Finalized Date is the name of the dimension) , i want each of these measure detailed by modality, i did it for average but i am unable to code the measure for Maximum and Minimum, can anyone of you please have a look at the attached worksheet and help me out.

• ###### 1. Re: Rotation Maximum to be detailed by Modality

Hi Parul,

Thanks for sharing your challenge. Upfront a question concerning your dataset

As depicted for each Modality eg CR there are multiple sessions 7-9, 8-9 and 13-9.

Would you like to know AVG, MIN and MAX based on Rotation, Report...., Modality and Report finalized date(Session)?

Hope to hear from you.

• ###### 2. Re: Rotation Maximum to be detailed by Modality

Hi Norbert,

Thank you for looking into this, i will explain this bit more, please find the excel attached herewith which is my data source for the worksheet,

Each Exam done will have a unique Accession number (Column B), Column E is Report Finalized By, if i filter for value AJ, then for column F i get two values - 29 July and 5th Aug, so

1. If i want to calculate Maximum Volume for Rotation then first i calculate average Volume for individual Radiologist for the Rotation, in our example AJ's average should be (sum of number of exams done)/(number of days worked in the given rotation) which is 139/2

2. I repeat the same step for other Radiologist's on the same rotation and then i pick Maximum Value which becomes my MAXIMUM VOL FOR ROTATIONS measure

3. Similarly i calculate Minimum value.

4. In order to calculate  AVERAGE VOL FOR ROTATION i perform (total sum of number of exams/ total working days) meaning for CNP/COLLEGE PLAZA MRI rotation the average volume should be 887/22

I want all the three measures by Rotation, Report Finalized By and Modality.

I hope this helps.

If you have any further question please let me know.

Thanks

Parul

• ###### 3. Re: Rotation Maximum to be detailed by Modality

Hi Parul

Find my approach as reference below and stored in attached workbook version 9.3

• ###### 4. Re: Rotation Maximum to be detailed by Modality

Hi Norbert,

I really liked your approach and learned lots of new things from the workbook today, thank you for sharing knowledge

But the problem is that when i drag modality on color for the MAX value i should see breakdown of MAX by modality which is what  is my real challenge, i have done this breakdown by modality for Average value as you will see in Sheet 1. I want to achieve the same for MAX and MIN

Please find attached workbook where you will see exactly what i am looking for.

Hoping for help.

Thanking you.

Parul

• ###### 5. Re: Rotation Maximum to be detailed by Modality

Goodevening Parul,

Find my approach concerning "Modality" as reference below and stored in attached workbook version 9.3

1 of 1 people found this helpful
• ###### 6. Re: Rotation Maximum to be detailed by Modality

Hi Norbert,

Thank you for helping me out here, but what i want is something like below for Max value. As you can see in snapshot below the first green bar has a value of 114.18 which is further detailed by modality in the dashboard below.

Similarly if i detail Max by modality the resultant value after adding the values for modality should be the value of Max.

ex. for CNP/COLLEGE PLAZA MRI rotation the Max value is 30.25 in our worksheet, when i detail it by modality in a bar chart, the sum of modalities on that bar should be equal to 30.25

Parul

• ###### 7. Re: Rotation Maximum to be detailed by Modality

Hi Parul,

Find once again my approach based on your feedback below and stored in attached workbook version 9.3

1 of 1 people found this helpful
• ###### 8. Re: Rotation Maximum to be detailed by Modality

Thank you Norbert for all the help, I really appreciate. I have incorporated your approach in my workbook and it has really helped understanding data in a more better way

• ###### 9. Re: Rotation Maximum to be detailed by Modality

Good evening Parul,

Glad I could help out. Thanks for the "Awards". Much appreciated.