Forum Discussion
Create Quartiles by Groups and Removing Specific Values
Hi Anonymous ,
I am sorry. I also don't know what Temp_Table and Main_Table are. How to get 0.65 and 0.8. Why the rate data is not the same? Can you provide more detailed data and desired output?
Best Regards
Community Support Team _ polly
AlexisOlson Anonymous
I am sorry, I changed the table names on you:
- Temp_Table = Quartile1 Table. Because I'm summarizing I have to make a summary table and can't do calculated column or measure.
- Main_Table = dataset
The 0.65 and 0.8 are the Quartiles that I calculated manually (I have thousands of rows so this isn't a possibility on my data). For example, In a normal scenario, if I am calculating the first Quartile for the FDR Subclass for Time 12, normally, I would just group everything from 'dataset':
| Time | Class1 | Class2 | Subclass1 | Subclass2 | Vendor | SKU | Rate |
12 | 1 | REF | 11 | FDR | A | 111 | .089 |
| 12 | 1 | REF | 11 | FDR | B | 112 | .112 |
| 12 | 1 | REF | 11 | FDR | C | 113 | .121 |
| 12 | 1 | REF | 11 | FDR | D | 121 | .080 |
| 12 | 1 | REF | 11 | FDR | E | 122 | .065 |
| 12 | 1 | REF | 11 | FDR | F | 131 | .050 |
But, for my reasons, I want to calculate the first quartile for Vendor A, but I want to remove Vendor A from the calculation so the 'Rate' that I'm using for this particular grouping is only using the following Vendors (For FDR subclass and Time 12):
| Time | Class1 | Class2 | Subclass1 | Subclass2 | Vendor | SKU | Rate |
| 12 | 1 | REF | 11 | FDR | B | 112 | .112 |
| 12 | 1 | REF | 11 | FDR | C | 113 | .121 |
| 12 | 1 | REF | 11 | FDR | D | 121 | .080 |
| 12 | 1 | REF | 11 | FDR | E | 122 | .065 |
| 12 | 1 | REF | 11 | FDR | F | 131 | .050 |
And the same logic applies for all the other vendors. When I want to calculate the first quartile for vendor B, I want to remove Vendor B's rate from the calculation. And for Vendor C, I want to remove Vendor C's rate from the calculation...etc.