Questions tagged [percentage]
Percentage is a ratio or fraction of a quantity that shows the ratio from whole part of quantity. Percentage demonstrates how much is there out of 100.
percentage
2,740
questions
-2
votes
0
answers
19
views
Calculated % based on each individual name
Can someone help with the formula i should used for a calculated field in google/looker studio.
I have a dataset of employees who have completed their timesheet and I need to create a new field ...
0
votes
1
answer
29
views
Create a percentage using a based field and a based item in SAS
Data sample
Cohort Years Count Status
2021 2 1 Graduated
2021 1 1 Active
2021 0 1 Active
2022 1 1 Graduated
2022 0 1 Active
2017 1 1 Active
2017 6 ...
0
votes
1
answer
30
views
Weighted percentages?
it's been a while since I have been working formulas and sheets and I can't get my brain to function.
I have two percentages: A) 120% and B) 179%, of which A) is weighted with 65% and B) is weighted ...
1
vote
1
answer
27
views
How to transform percentage form for variance decomposition
I have a data like this,
library(vars)
##### Step 1. dataframe #####
var_1 <- ts(c(0.0242964582, 0.0294573276, -0.0406138524, 0.0734349713, 0.2361871259, 0.2029464090,
-0.0674527667, -0....
0
votes
1
answer
44
views
How to update mui slider value with input field?
MUI slider running with min and max value with
const minVal = 8; const maxVal = 255;
<Slider
value={range}
min={minVal}
max={maxVal}
onChange={handleSliderChange}
valueLabelDisplay="...
-2
votes
2
answers
44
views
How to find percentage on in SQL?
I have data like this:
I want to find the percentage as a third column for each row, No- 549/(549+342)
Yes - 342/(549+342)
I have tried select Survived, cnt, round(100*(cnt/sum(cnt)), 2) as prcntage ...
1
vote
0
answers
33
views
Calculation of compound percentage - inaccurate result with specific input data
I am creating a function that calculates the compound percentage. It is enhanced by adding periodic deposits and tracking the results month by month.
Everything works fine, but when I set the ...
-1
votes
2
answers
56
views
Why is my query just returning O's instead of the percentages of the whole?
I attempted to divide to see the percentage each, medical practice provides of the data and nothing came out, just zeros in each row. enter image description here
I attempted to convert it into a ...
0
votes
1
answer
33
views
How to find average per day using pivot table?
I have following data that shows distribution of fruits on each date.
I want to achieve the following format via Pivot Table, that shows percentage of Apple on each day and show the average at the ...
-1
votes
1
answer
59
views
Get percentages in query [duplicate]
Thank you for your assistance.
I can't get it to divide? Is it because its the Modulo operator?
I've reviewed and scoured the web for a bit, but it just doesn't seem to be working.
How do I get a ...
0
votes
2
answers
53
views
Creating a table with percentages of one variable
I would like to make a table that looks like the attached image in Markdown
The variable I'm looking to report on is happiness. The survey question asked people whether they are very happy, happy, ...
0
votes
2
answers
40
views
How to get a percentage of a subcategory in a column
I am using mysql workbench 8.0
I am teaching myself SQL and am currently starting on some guided projects with a LOT of googling. Right now I am working with this data:
Here's the relevant section I ...
0
votes
0
answers
39
views
How can I calculate the subtotals and add auto percentage in a pivot table in Pandas 2.0.0+ like in Excel? Without using append (it removed)
I've data like that:
data = {
'nomenclature': ['Display_product', 'Display_product', 'Decorative_textile', 'Decorative_textile', 'Children_clothing', 'Children_clothing', 'Children_textile', '...
1
vote
1
answer
59
views
absolute difference giving minus percentages
I have a DataFrame to find the percentage of absolute difference between two sources in python. But when I use the below code, few of the columns are giving the -% (minus percentages)
I have checked ...
0
votes
0
answers
30
views
How do I make a stacked bar chart created from a Pivot table arranged from descending order (largest - smallest) in Excel?
I am creating a dashboard and have added a stacked bar chart that totals up to 100 % of the inputs in the production cycle. The stacked bar chart was created using a data in a Pivot table. The input ...