753 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
42
views
Showing actual percentiles in locust reports
Is there a way to compute proper percentiles in Locust? The values are always rounded off to a multiple of 10.
I have read about Locust only estimating percentiles to save resources. But is there a ...
0
votes
1
answer
73
views
Joining two tables while ignoring null values in some columns
I am trying to join two tables on muliple criteria, however the set of criteria would be different for each row.
Then, in addition, I want to get a percentile rank for values from one column from one ...
0
votes
0
answers
55
views
PromQL Percentile Report in Grafana
I wanted to find the 99 Percentile Report using PromQL in Grafana.
I use the following Query to get the data from PromQL
ifInOctets{instance="172.6.5.4", ifAlias="ISP1"}
Now I ...
1
vote
1
answer
86
views
How Can I Match Percentile Results in Postgres and Pandas?
I am making calculations in the database and want to validate results against Pandas' calculations.
I want to calculate the 25th, 50th and 75th percentile. The end use is a statistical calculation so ...
1
vote
0
answers
34
views
Get overall percentile across non contiguous time ranges
In this Grafana heat map representing a histogram, how can I get the combined p95 of the two circled distributions?
I can get the overall p95 for the entire time range shown above using ...
0
votes
1
answer
71
views
Percentile formula limited to lookup value in array in separate sheet
I have a dataset in Sheet 1 where the data forms a long vertical-scrolling list, i.e.
A B C D
Location Param Value Date
L1 Conductivity 1,250 01/...
0
votes
1
answer
220
views
Creating deciles in SQL
I'm trying to bucket my data into deciles, but not in the traditional sense where the dimension is the basis of the decile.
I have 463 unique it_scores ranging from 316-900 (my dimension) with 1,296,...
2
votes
1
answer
107
views
Explaining the different methods for percentile calculation in NumPy
I was trying to create some box plots of data I have. I first was plotting them using Excel, but wanted to move on to Python to be able to personalize them. However, I was surpiresed to see the ...
0
votes
2
answers
64
views
How to create variable that shows the percentile ranges an observation is in
Say that I have the iris data.
I know that I can create a variable that shows the values that fall into a certain percentile:
library(tidyverse)
iris %>% mutate(Range = cut(Sepal.Length, quantile(...
0
votes
1
answer
50
views
Assigning a Percentile Range based off a Product/Retailors Revenu
I'm dealing with quite a puzzle at work within Pbi that I/ChatGPT/Co-pilot can't figure out.
I created a summary table of this dummy data set to showcase what I'm trying to do (image attached)
I'm ...
0
votes
0
answers
32
views
Python percentile functions give weird results [duplicate]
I am trying to calculate percentile(0.05) to percentile(0.95) with 0.05 as step. I did some test and one of the implementation gave me weird results. I couldn't figure out why. I will just use ...
1
vote
1
answer
139
views
Calculating percentile over a sliding window in Power Query
I have a table with 5 columns, District (type text), Month Cumulative (Int64.Type), Measurement (type text), Value (type number) and Monthdate (type Date, 1/mm/yyyy). The table is sorted on District ...
0
votes
0
answers
845
views
How to calculate percentile using PERCENT_RANK() using ANSI SQL
I am trying to calculate 25 percentile,75 percentile, 95 percentile and 99 percentile for datasets that have multiple columns, ID-Count, x , y , etc.
I am using Amazon Athena which support Presto SQL.
...
0
votes
0
answers
61
views
Assigning points based on quartiles (percentiles) according to a grouped virtual table
Good day to all!
I have a table with tasks that one or another counterparty (person) performs
My task is:
Group the data by counterparty and how many tasks he completed
Find the value of 25% 50% 75% ...
0
votes
1
answer
95
views
combining 50th percentiles curve gamlss in one plot
I am a seasoned R programmer trying to help my friend to visualize percentile growth curves using gamlss. I have been successfully produce the curve for each group. Now the problem is she asked me to ...