2,734 questions
0
votes
1
answer
97
views
Calculate percent of total per firm and filter firms above 50%
I'm trying to calculate the percentage contribution of each firm to the total amount across all firms.
Database:
google-bigquery
What I need (desired output):
Sum usde_haircut_amt per firm
Compute ...
0
votes
2
answers
113
views
Weighted percentages
I have a problem on how to calculate "partial" percentages that match the "total" percentage.
My problem is as in the table below.
I have values for the beginning and end of the ...
- 391
0
votes
0
answers
32
views
Creating a Line graph & Matrix showing % Difference from Previous Year, allowing for a filter on "Country"
I have raw data with columns "Year", "Period", "Country", "Sales Amount". Please note there are 13 periods in a year, (and not 12). The dates also differ ...
- 1
2
votes
0
answers
99
views
Matrix table in power bi
I have a table Feature_Site, I want to count the featureCode by FeatureStatusDescription, I already have a measure that gives me the feature count
Totl_features =
COUNT ( Feature_Site[FeatureCode] )
...
- 57
0
votes
2
answers
126
views
Subtract values from following rows and calculate percent change
I have a dataframe where I wish to generate an additional column with the value of the percent change calculated as the difference from the former row divided by the original value, then multiplied by ...
- 537
1
vote
1
answer
50
views
Child element inherits percentage instead of computed value
I'm stumped by the following:
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-...
- 37
-2
votes
1
answer
48
views
Cursor to update 2 columns based on percentage increase on relevant data on same table
EmployeeName
Date
Salary1
Salary1_Percentage
Salary2
Salary2_Percentage
Alex A
2025-01-01
50
0 %
25
0 %
Alex A
2025-02-01
100
100 %
50
100 %
David C
2025-01-01
50
0 %
10
0 %
David C
2025-02-01
100
100 ...
- 49
0
votes
0
answers
94
views
Humio Crowdstrike Falcon LogScale Divide subset of a field by total of a field
I am trying to calculate a percentage using Crowdstrike Falcon Logscale, formerly known as Humio. The equation I need to calculate is percent_red_widgets = widgets_redl / widgets_total) * 100. The ...
- 471
2
votes
3
answers
127
views
Showing percentages of strata in alluvial plots
I have data on an intervention study with 4 experimental groups (Group), and three measurement points (Time). I conducted a profile and transition analysis, which yielded 4 profiles (Profile). I made ...
- 23
0
votes
0
answers
72
views
Autograding from GitHub won't aprove program for giving percentage from one number over other
My teacher on C++ gave us a test to get used to GitHub, coding in the langauge. For doing so, he tasked us to make two programs. One of them performed well with autograding, but the second simply can'...
0
votes
0
answers
27
views
R: ggplot2 and facet plot. Conditionally using percentage scale [duplicate]
Please have a look at the reprex example at the end of the post (I can simplify it if needed). I plot several quantities and those bound in [0,1] are percentages.
I would like, in the facet plot, to ...
- 1,543
0
votes
0
answers
25
views
Find the pecentage of sites with observations less then 200 from a dataframe [duplicate]
I have a dataframe in r that looks like this:
watername
siteid
length
bush
bush001
294
bush
bush002
186
bush
bush003
354
bush
bush003
202
bush
bush004
194
middle
middle001
306
middle
middle002
154
...
- 189
0
votes
0
answers
53
views
Change in % calculation from previous year using custom fiscal week numbers
I need help with creating a working dax formula in Power Bi desktop.
I am trying to calculate percentage change year over year but using fiscal week numbers as we have a retail 4-4-5 custom calendar ...
0
votes
1
answer
44
views
Countif Confusion and troubleshooting
Each column identifies where a particular student falls in their lexile readings. I am trying to place a percentage by adding up the columns and comparing it against the remainder of the columns. For ...
0
votes
1
answer
90
views
Excel dynamic images based on percentage values and removal of checkbox description during hover
I am using MS Excel 2016 and I have here a Habit Tracker created with a growing plant images in it based on the percentage of a cell. I have a problem about getting the correct image to certain ...
- 785
0
votes
4
answers
62
views
Can I calculate the percentage of a value and summarize this information over every sampling-date?
Date
Tree
Compound
Compound_mg
%mg
13.1
a
C21
5
13.1
b
C21
4
x
13.1
c
C21
9
20.2
a
C21
6
20.2
b
C21
5
x
20.2
c
C21
10
13.1
a
C23
6
13.1
b
C23
6
x
13.1
c
C23
10
20.2
a
C23
5
20.2
b
C23
4
x
20.2
c
C23
9
...
- 3
0
votes
0
answers
68
views
Why can't I assign percentage values to CSS using React Javascipt?
I have the following code which plots a bargraph component on the screen:
import '../styles/GraphBar.css'
function GraphBar({value, maxLength}) {
const height = (value / maxLength) * 100 + &...
- 39
0
votes
1
answer
49
views
Oracle SQL - Get rows where it meets a percent allocation
I am working on selecting participants for a program based on certain criteria and after meeting the criteria, get x% (say 60%) from a specific department A, and the remaining 20% from another ...
- 161
1
vote
2
answers
171
views
Is there a function to calculate a percentage of a number in R?
Let us say we want to calculate a certain percentage of a number, e.g. 50% of 80,000. We can of course write a quick calculation, e.g.:
> 80000 / 100 * 50
[1] 40000
Since I don't calculate ...
- 821
0
votes
1
answer
49
views
Calculate total percentage with total N and events in two data frames in R
Working with some event data from a dataset that has multiple different courses across multiple semesters. I need to find out how many students "logged" into the course each week and then ...
- 35
0
votes
1
answer
171
views
Convert pixel to percentage React-Native javascript
I'm building an app on RN and I made the mistake to put my values in pixels instead of percentages so it fits with all screen sizes...
Can someone help me convert the values in my const styles into ...
user27053061
0
votes
1
answer
90
views
R dbplyr percentages not calculated correctly from live connection to Microsoft SQL Server [duplicate]
I have a Microsoft SQL Server database which I have connected to with an ODBC link. There are three columns of interest in the table I am querying: serovar, reportyear and hospitalised.
Each row ...
- 1,103
0
votes
2
answers
89
views
Yearly rate change based on one or two columns in r
My data looks like this
structure(list(year = c(2017, 2017, 2017, 2017, 2018, 2018, 2018,
2018, 2019, 2019, 2019, 2019, 2017, 2017, 2018, 2018, 2019, 2019,
2017, 2017, 2017, 2017, 2018, 2018, 2018, ...
- 33
0
votes
1
answer
71
views
Finding percent cover of a raster image
I Have a raster layer in QGIS - The raster symbology represents 5 classes ranging from <0.2% to 0.9%. These classes represent vegetation densities. I would like to know what percent of each class ...
0
votes
1
answer
37
views
Displaying percentage of audio tags loaded cross-browser, with accuracy so that controls are unavailable until everything loads
I have a bunch of audio tags in child iframe that look like this :
<audio id='n0' preload='auto' onCanPlay='CountASampleAsLoaded();'><source src='Sounds/0.mp3' type='audio/mp3'></...
- 19
0
votes
0
answers
63
views
percent stacked bar chart not scaling to 100% [duplicate]
It's clear I'm not understanding the math behind what I wish to accomplish. I want a stacked bar chart showing the percent contribution of each contamination source to the total ASV counts per sample....
- 474
0
votes
1
answer
50
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
60
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 ...
- 87
1
vote
1
answer
51
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....
- 71
0
votes
1
answer
87
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="...
- 27.7k
-2
votes
2
answers
52
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,874
1
vote
0
answers
39
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 ...
- 103
-1
votes
2
answers
80
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 ...
- 1
0
votes
1
answer
63
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 ...
- 152
-1
votes
1
answer
73
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 ...
- 1
0
votes
2
answers
203
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, ...
- 11
0
votes
2
answers
47
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 ...
user25242073
1
vote
1
answer
80
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 ...
- 79
0
votes
1
answer
207
views
Calculate a running percentage to increase the total each month to get end with 1000
I'm attempting to calculate the percentage increase needed month over month, with the first month starting at 20, to end the year with 1000.
I envision the solution to be something like last-month(20)*...
- 60
0
votes
1
answer
88
views
How could I change all values in a dictionary by a percentage?
Is there a easy way to change every dictionary value by a percentage or do I have to loop through them all and change them by a percentage lets say 2%. So the first one that is 100 would change to 102%...
- 23
0
votes
1
answer
63
views
How to find the percentage change of two graphs
I have two graphs and would like to find the difference between them in percentage.
First I converted them into lists:
Graph_1=[3843.788185, 3734.256494, 3572.574207, 3420.958554, 3254.79344, 3008....
- 31
-2
votes
1
answer
392
views
Excel IF statement to work with comparing two percentage values and producing a third
I am trying to compare two percentages and produce a third percentage
For example:
The Threshold (column B) is the expected standard
The Availability (Column A) is the actual received
The Credit (...
2
votes
1
answer
291
views
How to define size of radial-gradient css as a percentage?
How can we define the size of radial-gradient in percentages instead of pixels?
radial-gradient(circle 300px at 5% 20%, red, blue 100%)
I want the gradient to adapt to the size of its container ...
- 3,395
1
vote
1
answer
57
views
How to calculate the percentage of change on rows with NA
How do I find and calculate the percentage of change of an indicator throughout time when there are several NAs spread throughout the data?
Let's assume that this is my dataframe:
a b c d ...
- 25
0
votes
3
answers
104
views
python Count of ID's for percentage levels
I have the table like below which is stored in a DataFrame. I want to add the
tolerance_level = [0, 1, 5, 10, 20, 30, 50, 100, 200, 300, 500, 700] and
get the count of ID's for columns A, B, C that ...
- 79
0
votes
1
answer
50
views
Count percentage of value "1" for each column AND for each group on specific variable
ID AT07 DT01_1 DT01_2 DT01_3 DT01_4 DT01_5 DT01_6 DT01_7 DT01_8 DT01_9 DT01_10 DT01_11 DT01_12 DT01_12.1
1 vD0FPVt AT07_1 1 1 1 1 1 1 1 1 1 1 ...
- 117
0
votes
1
answer
32
views
Is there a way I can add a % sign to my results
I am currently calculating percentages for my data set:
How can I add the % symbol at the end of the numbers?
round((df.value_counts('label')/df.value_counts('label').sum()) * 100)
results:
label
...
- 3
0
votes
1
answer
150
views
how relative width is calculated in css
i am beginner in web development,
i want to make my home-page element (div) to flex column in which first element is a flex row container which again contains a flex container div (icons)
when i did ...
- 51
-1
votes
1
answer
53
views
R code - Make a plot for survey responses
I am trying to make some barplots with my data but I keep hitting some walls. If someone on here could help that'd be great
I wanted to create barplots with side by side comparison of pre vs post ...
1
vote
2
answers
65
views
How to check what percentage of a column is made up of certain rows
I have a CSV file that is too large to be opened in Excel. In this file, I am trying to see how much of each column's sum is from rows 1, 47:56, and 156:158. This does NOT include the first two ...
- 57