Forum Discussion
Quartiles chart
I have a set of data for multiple years for multiple companies from multiple sectors. Overall more than 30k rows of data. I am trying to create a chart only for a specific year which shows quartile values for each sector. Below is a sample table for the overall dataset and also the output from a PPT file. It would be great to have filters & slicer functionality for the chart like flip between years, compare multiple-year values for a single industry or even see data from multiple industries simultaneously from a selection of industries. Lower Quartile - 25th Percentile, Upper Quartile - 75th Percentile.
Please help.
Best Regards,
Amit
| Company Name | Financial Year | Net Working Capital Days | Industry |
| A | 2018 | 2 | Retail |
| A | 2017 | 5 | Retail |
| B | 2018 | 3 | Retail |
| B | 2017 | 6 | Retail |
| C | 2018 | 4 | Retail |
| C | 2017 | 7 | Retail |
| D | 2018 | 5 | Pharma |
| D | 2017 | 8 | Pharma |
| E | 2018 | 6 | Pharma |
| E | 2017 | 9 | Pharma |
| F | 2018 | 7 | Pharma |
| F | 2017 | 10 | Pharma |
| G | 2018 | 6 | Retail |
| G | 2017 | 4 | Retail |
| H | 2018 | 8 | Pharma |
| H | 2017 | 9 | Pharma |
2 Replies
Please check the solution I had provided earlier
Cheers
CheeuSing
That solution doesn't work here as it just helps in calculating the quartile values based on filters. I am trying to build the visual as well which is same as the image attached in the original post.
