628 questions
0
votes
0
answers
58
views
DAX Minimum of a count within a Group
I have a dataset with dates and hours and a count of the number of events within each hour. I want a measure to take the minimum value of the count within each hour.
So the min count by hour column ...
- 1
Advice
0
votes
4
replies
63
views
In Dockerfile add user, assign group to user and make group permanent
I have a Dockerfile, where I create a non-root user and assign a group icmp_users to it. However, when I run the container with docker run -it --rm container bash the group is not activated.
Here is ...
- 1,132
0
votes
0
answers
24
views
Moodle Group Assignment using code not update restriction access
so im currently developing a local plugin on Moodle 4.4 that are auto assigning user to a group. Here the case:
In my course, when a user attempts a quiz (e.g., Quiz 1) and fails to achieve a score ...
- 13
2
votes
1
answer
78
views
Moving Group-Element to numeric-edited field vs moving alphanumeric field to numeric field
When trying to make a Date readable we sometimes use numeric-edited field,e.g.
01 Date-Readable pic 99.99.99.
Decimal-Point is comma is in effect.
Although this solution is not how the decimal point ...
- 55
0
votes
0
answers
79
views
Access Intune group memberships on Local Device
as part of a move to Intune, we still have some legacy applications that are accessed via group memberships.
Is there a way to use powershell to enumerate Intune/AAD group memberships without calling ...
- 13
0
votes
0
answers
42
views
Why does an unassociated docker container have a different user
I'm running Ollama on a server. I've never logged in as the ollama user that's created on installation. Note that this is a native Ollama installation on Ubuntu 22.04, not a docker image.
Many days ...
- 178
0
votes
1
answer
256
views
How to apply SORTBY with a FILTER HSTACK list outputs to group lines by date range and category
I have a filtered table which collects certain columns from another tab (yourcorp), displaying only the values which fulfil certain criteria. Now I need to further sort the list, which I tried to do ...
- 21
0
votes
1
answer
70
views
Comparing dates within a group but between variables (within a site but between record types)
I am working with invasive species data for an analysis that compares pre- and post-treatment data to determine treatment effectiveness. For each site, I have data on presences (records of the ...
- 1
0
votes
0
answers
60
views
Custom Claim expression language for group
I'm trying to get list of roles in below structured format. But i'm unable to get groups using expression language. Can someone help me achieve this?
"group_access": {
"roles":...
0
votes
0
answers
31
views
odoo 16 community version. website restriction
I am using odoo16 community version and i have a lots of websites and users. I want to restrict some users to edit some parts of the website like header, footer, menu... In order to keep the standard ...
1
vote
1
answer
54
views
Count And Grouping with PHP and MongoDB with PHP
Manipulating JSON array using PHP and MONGO DB.
I have the following nested JSON, I need to counts the Repeated Persons to depurate the collecction, in the sample are 4 records but really are 2000 ...
0
votes
0
answers
36
views
Test statistic T in MRPP with vegan package
I'm running mrpp() function from the package vegan. I'm currently trying to move my analysis from PCORD to R so I'm developing a code to match the results. PCORD calculates an statistics test T which ...
- 11
1
vote
4
answers
75
views
Grouping only specific numbers and finding the sum of a separate column using R
I've found ways to create groupings from variables but not how to create a single sub-group.
df <- data.frame(days = c(0,1,2,3,4,5,6,8,10), n = c(408,51,103,112,35,17,7,6,1))
What I want to do is ...
- 11
1
vote
2
answers
111
views
Creating an R function (or a loop) to count the number of samples that lie above and below a range for each column in a data frame
I have a data set with different groups and many columns with different variables. For each column I want to calculate the range of values in one group, then count how many rows have a value that is ...
- 13
2
votes
1
answer
29
views
Google Spreadsheets - Grouping cells in 1 row + sorting based on value/colours in the column
Hi everybody,
I'm new to Google Spreadsheets and I found a lot of tips online but some things won't work at all.
Every person to the left (A9:A23) has a particular race schedule and this sheet is a ...
0
votes
1
answer
76
views
Find all access rights on a filer for a specified group
I'm looking for a solution to scan recursively a filer for all directories to find, where a specific group has access rights.
My first try was this:
get-childitem "C:\temp" -directory -...
- 1
0
votes
1
answer
45
views
How can I connect two groups of lines in ggplot2, when one group is a single black line and the other group is multiple coloured lines?
I am trying to create a plot that looks like this (mockup in Powerpoint):
Unfortunately, I can only manage to get this (A):
Or this (B):
Or this (C):
What I've tried:
data < - examp = ...
- 23
2
votes
1
answer
54
views
How do I represent sided boxplot in seaborn when boxplots are already grouped?
I'm seeking for a way to represent two sided box plot in seaborn.
I have 2 indexes (index1 and index2) that I want to represent according to two information info1 (a number) and info2 (a letter)
My ...
- 5,207
-1
votes
1
answer
39
views
comparison between two strings for a group of unsorted values
My SQL returns 2 columns with concatenated strings, I split both the columns in power query and I want to use DAX to do a comparison on the values in both the columns for every ID column. The measure ...
1
vote
1
answer
93
views
Pyspark - cube aggregation
I'm trying to use the cube function in pyspark without including all the columns in the cube.
SQL equivalent of what I am trying to achieve:
select col1, col2, col3, sum(col4) from table
group by ...
- 475
1
vote
0
answers
55
views
How do I group results of a query in wordpress
I've got a custom post type for staff. The fields are first_name, last_name, job_title, telephone, email, and notes. All staff are categorized by location using WP core Category. I need to output the ...
- 115
0
votes
1
answer
266
views
GROUP BY and calculate average
I would like to create a column in DAX where I calculate the average quantity sold. In the table I have the week number and the sold quantity on that specific week but in the additional column I would ...
0
votes
1
answer
93
views
Grouping in vespa yql query excluding non whole numbers
I am attempting to modify a vespa query in my code base. I am grouping in this query to collect min/max values. But now I am wanting to gather a max value for a value called operatingWeight. The issue ...
- 498
3
votes
1
answer
145
views
Excel Formula: Filter Group based on Smallest Values
Excel Formula
With the use of an Excel (Not VBA) array formula or similar preferably, due to the size and amount of data, I need to reduce the least amount of resources necessary to optimize ...
- 405
0
votes
0
answers
41
views
Unable to Draw Custom Border Around SWT Group Encompassing Title Area on Linux
In an SWT Java application, I am trying to draw a custom black border around the Group widget (with title text) that encompasses the entire group, including the title area. The goal was to ensure the ...
- 1
2
votes
3
answers
155
views
find the first TRUE within a group
I want to save the position of the first TRUE in level variable within each id. I am doing the below:
library(tidyverse)
data <- data %>%
group_by(id) %>%
mutate(first_true = min(which(...
- 587
0
votes
1
answer
47
views
How to interleave columns in sqlite
In SQLITE I have a table with three columns like so:
X Y Z
_____
1,2,A
1,3,B
3,4,C
I want what follows, order of the rows does not matter.
U Z
___
1 A
2 A
1 B
3 B
3 C
4 C
So then I can GROUP BY U ...
- 11
-2
votes
2
answers
73
views
Need to create group based on actions
I have a table and I am only interested in two columns to perform two actions (Ignore or Good), and based on actions I need to keep only "Good" rows. I have tried several SQL windows ...
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
72
views
SPL Add the time from next row in new column
I am working in Splunk where I need to know what the difference is between two timestamps in the same column. My idea was to add the next value in a column to find the difference.
For example
...
0
votes
1
answer
38
views
Data separation, applying changes and finally combining the result
I have written a series of lengthy commands. I would like to learn how to condense them using a for loop or another concise command.
df.col.unique()
#array(['a', 'b',....,'x', 'y']
a = df[df.cal== &...
0
votes
3
answers
77
views
How to aggregate only parts of members of each group in one query statement in PG?
I have a table people(gid int, name varchar) with data:
gid name
1 Bill
2 Will
2 Musk
2 Jack
1 Martin
1 Jorge
now I want to get a result set like ...
- 417
0
votes
0
answers
94
views
Create VBA code to group by tasks in Ms Project according to string separated by coma
I am trying to group by task in Ms project however the functionnality already existing only groups by entire string found in the cell. I want to however classify task according to multiple string ...
0
votes
0
answers
39
views
Populate a ObjectId deep nested inside arrays and objects preserving document shape
I'm using MongoDB v5 with NodeJS (no Mongoose).
Let's say I have a collection structured the following way. This specific setup (an ObjectId nested inside an object contained inside an array contained ...
- 109
1
vote
2
answers
76
views
Filtering a dataframe in Base R 4.3 using the native pipe
I download a monthly time series of unemployment rates from the Federal Reserve using alfred
df <- alfred::get_alfred_series("UNRATE")
As unemployment data is later revised after its ...
- 1,131
0
votes
1
answer
39
views
regroup tupples in different group with kmeans method using only a number in position 0
liste = [ (1, ["A",1,"C"]) , (3, ["A",1,"C"]) , (1000.256, ["B",1,"C"]) , (1002, ["C",1,"C"]) , (5, ["D",1,&...
- 105
1
vote
1
answer
42
views
loop to select the date closest to another date, for multiple variables [closed]
For each MRN ID, I would like to select the date (in OBSERVATION_DATE), in association with various columns (i.e. hdl, ldl, and vldl) that is closest to the dates listed in multiple other columns (i.e....
- 123
3
votes
1
answer
60
views
geom_histogram cluster values with same fill category together
I'm trying to create a histogram which uses one column in the data set for the fill colour and another column in the data set for the groups. Both of these are define within the aes(). Then I add a ...
- 1,103
1
vote
4
answers
76
views
Group Data into sets by date intervals in oracle
I have data like the one below and am looking to get it grouped based on the time intervals where it is repeating for col1+col2 with start and end dates. Can anyone provide some tips to get the result ...
- 127
1
vote
2
answers
41
views
Oracle SQL Grouping same value records in particular order
I have simple table of Time and Task columns where it is ordered by Time and has associated task to it as per below example.
Question: How to group the tasks and get the earliest time of every time ...
- 13
2
votes
4
answers
72
views
modify/create column based on groups defined externally
I have a predefined list containing a list of items as below:
group_1<-c("A","B","C")
group_2<-c("D","E","F")
item<-c("A"...
- 569
0
votes
0
answers
15
views
R plot multiple lines grouping data [duplicate]
I have the following dataset :
date prmd N Tx
1: 2023-10-31 UAE 102889
2: 2023-10-31 UB 15183
3: 2023-11-30 TX 2
4: 2023-11-30 UAE 94110
5: 2023-11-30 UB 15339
6: 2023-...
- 23
0
votes
1
answer
26
views
Trying to repeat Group Header in the right side column in a multi-column report
I've created street listing report in Crystal Reports 2020 that is multi-columned. The street name appears fine in the Group Header section but only in the left column. It doesn't repeat or appear in ...
0
votes
0
answers
33
views
How do I count overlapping variables in R? [duplicate]
I am trying to figure out how to get counts for intersectional variables. For example, I have the categorical variables Female, USA and HighIncome and I'm trying to see how many people I have at the ...
- 1
0
votes
0
answers
47
views
Shrink a Pandas data frame by groups in a column [duplicate]
I tried to change this data frame:
X_Coord Name MaxDisplacement
0 1 0.03 11
1 2 0.03 22
2 3 0.03 33
3 1 0.02 ...
0
votes
3
answers
80
views
How to Group 0 with NULL in mysql select
I know there are many variants of this question, but none seem to address my issue.
I have a page reporting website order stats. One of the variables it considers is which 'website' a customer used.
...
- 37
2
votes
2
answers
144
views
How do I Join Cells from different rows in PowerShell
I am fairly new to PowerShell and just trying to get plug some gaps with my main support role using PowerShell, so far its been great however I am currently stuck on trying to find a solution for the ...
- 33
0
votes
1
answer
68
views
Excel InputBox: group shapes and name groups with unique names
This code allows the user to group shapes in a selected range and name the group with a unique name.
It uses 2 InputBoxes:
"1/2 Select Shape Range"
"2/2 Enter Group Name"
Bug: If ...
- 109
0
votes
2
answers
62
views
python duplicated row in a group [closed]
I need a function, or a sentence, to identify duplicated rows in a group.
For example, if we have this dataframe, grouping by column ID 1, I need see if values of ID 2 are duplicated within its group, ...
4
votes
2
answers
92
views
Direct way for 'distinct() groupwise'
I would like to make the same like distinct() but for groups. Here is an example:
data <- data.frame(
group = c(1, 1, 2, 3, 3, 4, 4, 5, 5),
procedure = c("A", "B", "A&...
- 80.2k