Forum Discussion
alfertab
Apr 17, 2024Copper Contributor
Creating a graphic knowing at which time do we have the 90% of the data
Hi everyone, I'm having some troubles creating a graphic and I would like to know if someone knows how to solve it.
Basically I have a table like the following but with more data:
| Date | Day of the year | Year | Hour of the day |
| 16/05/2018 | 136 | 2018 | 17 |
| 27/06/2018 | 178 | 2018 | 23 |
| 22/05/2019 | 142 | 2019 | 22 |
| 05/08/2019 | 217 | 2019 | 16 |
| 02/09/2020 | 246 | 2020 | 21 |
| 27/10/2020 | 301 | 2020 | 18 |
| 25/08/2021 | 237 | 2021 | 21 |
| 11/11/2021 | 315 | 2021 | 19 |
| 20/05/2022 | 140 | 2022 | 24 |
With that data I created a scatter plot having the different days of the year in the X axis and the hour in the Y axis. I also used the year as a legend and the created visual is the next one:
The problem, is that I also need to know at which hours and at wich days we have the 90% of our data. Does anyone knows how to do it? The correct visual it should look like the following:
1 Reply
- SanthoshKunderIron ContributorIs the PERCENTILE formula in Excel useful for your task?