9,082 questions
0
votes
3
answers
73
views
make a list according to max count [duplicate]
I have a list
my_list = [3,8,11,8,3,2,1,2,3,3,2] # my list
max(my_list, key=my_list.count) # most frequent number appeared on the list
But i want to make a list according to the most frequent ...
- 45
0
votes
0
answers
35
views
Power BI - MIN/MAX Issue
I have the following matrix in Power BI with the measures "First Period", "Second Period", "<> Change", and "% Change" (the DAX code for the First Period ...
- 21
1
vote
1
answer
112
views
What is the return value of Array.max when array contains NaN?
Looking at the documentation for Array.max (https://developer.apple.com/documentation/swift/array/max()), I see it says that it returns "the sequence’s maximum element."
I wonder how that's ...
- 17.7k
0
votes
0
answers
31
views
React Native GiftedChat: Maximum update depth exceeded error on minimal example
I am building a chatbot screen in React Native CLI using the react-native-gifted-chat package (version 0.16.3). However, when I run even a minimal example, I get the following error:
Maximum update ...
- 21
0
votes
1
answer
64
views
Trying to search a specific column range of 45 to 64 only
My formula works but if 44 or less or 65 or greater number is entered, I get “XLOOKUP couldn’t find the requested value”. That’s why I want to limit the search to only include a number range from 45 ...
-3
votes
1
answer
98
views
VBA calculation of Maximum, minimum, Mean and Median for values in a column [closed]
For reasons unknown, the Application.WorksheetFunction procedures do not work on my Excel and so I am trying to do these calculations using VBA. I have written a sub routine for these calculations but ...
- 25
0
votes
3
answers
87
views
Google Sheets: Return latest date from one column depending on variables in 4 other columns
I am looking for a Google Sheet formula to help me find and return the date from another column, depending on variables from other multiple columns.
Here's a spreadsheet with my issue.
I would like ...
- 3
0
votes
1
answer
41
views
How to "decouple" additional columns from max() function in SQL
I have a table that displays values for some devices. Each row is a separate reading at a distinct time interval. Row 1 = reading at 00:00, Row 2 = reading at 00:30, and so on...
I want to get the max ...
- 11
0
votes
0
answers
11
views
Number of charactes per single word CSS [duplicate]
How do I set the limit of characters per single word within a text paragraph in CSS? Something like max-word-length. I am NOT talking about the total number of characters in the paragraph.
In fact, ...
2
votes
3
answers
98
views
Count the number of times a column has the max value in the row
In google sheets, How do you calculate the number of wins a player has from the sample data below? I want a formula to use for the win row.
The formula should count the number of times the player has ...
- 21
0
votes
2
answers
75
views
Getting single MAX() row of Calculated Column within a Specific Time Interval in SQL
I am trying to get the MAX() of the sums of amps_a + amps_b + amps_c within the month of March for the ID column. This should return a single row for the highest sum for the month of March (or at ...
- 11
2
votes
1
answer
57
views
Pandas group by - maximum row for a subset [duplicate]
I have a dataframe with weekly product sales
product_id
week_number
sales
A1
1
1000
A1
2
2000
A1
3
3000
A2
1
8000
A2
2
4000
A2
3
2000
I want to add a column that identifies rows where the total sales ...
- 213
3
votes
4
answers
210
views
Fastest way to find indices of highest value in a matrix iteratively and exclusionarily
For the sake of anyone who stumbles upon this in the future, I apologize – I had conceived of the problem and solution incorrectly. A proper implementation of finding the coordinates of pairwise best ...
- 33
0
votes
1
answer
72
views
MySQL Select MAX() & Group By do not work as I want [duplicate]
I have 2 tables with 50k+ & 10k+ rows
Table chapter
id (auto_inc) | chapter_id | story_id | date (timestamp)
1 | 1 | 1 | 1715830560
...
10 | 10 | 1 ...
- 117
0
votes
0
answers
26
views
Maximum call stack exceeded
Issue:
I used Clerk middleware, but it didn't work, and I encountered a Maximum Call Stack Error. Additionally, my middleware.ts file sometimes doesn’t compile.
Here’s my middleware.ts file:
import { ...
