Questions tagged [lag]
Lag is a common word meaning to fail to keep up or to fall behind. In real-time applications, the term is used when the application cannot keep up with performance demand or user input. In other words, it refers to when the application is not keeping up with it's "real-time" concept, due to problems related to poor rate of cycles-per-second, a (possibly cumulative) lateness of response to user input, or other problems.
2,133
questions
0
votes
0
answers
105
views
How to calculate a self-referencing ifelse value using acculmate ? Unable to solve (in R and using data.table) [closed]
I have an excel sheet I am replicating so I know what values I am searching for. The set up is simple:
I have a data table where I need to calculate the state of charge of 5 different types of ...
-3
votes
1
answer
76
views
MySQL Lead function returns NULL
I have this MySQL table:
id
Name
1
Spanish
2
French
3
German
I am using this statement:
SELECT id, Name, Lead(Name) OVER (ORDER BY id) AS 'next' from MyTable WHERE Name='French'
The expected ...
- 1,247
0
votes
2
answers
36
views
Postgresql select nearest max value row within 30 seconds timestamp
I need to extract data from a postgres table, where I want to look at nearby records within a 30 seconds of timesstamp with two columns match and fetch the value which is having max value.
id | ...
- 227
-1
votes
0
answers
22
views
Time Series forecasting, where historical values also gets updated due to lag
I am working on a time series forecasting of covid cases for next 4 weeks.
Incoming data frequency : weekly
Weeks to be predicted : 4
The main problem with the data is, there is lag in data of ...
- 53
1
vote
1
answer
36
views
pandas : sum with lagged param
in sql request, i have a chance to sum with lagged param on the fly, like:
CASE
WHEN dt_rep.fcr = 0::numeric THEN 0::numeric
ELSE (dt_rep.fcr - lag(dt_rep.fcr) OVER (...
- 426
0
votes
0
answers
71
views
Transparent / Absolute Canvas above animation causes GPU glitches
I made a small one pager which uses framer for scroll animations. I wanted to add a small smoke effect when scrolling past over a certain section.
The overall effect seems to function but it wrecks ...
- 8,646
0
votes
1
answer
31
views
Multi-Column Conditional Highlighting with KableExtra and ifelse statement
Solution Below
Original Question: I am attempting to highlight the text of a KableExtra table to indicate where group observations increase or decrease by year. However, I am receiving an error about ...
- 1
0
votes
2
answers
74
views
Snowflake get previous value that was different
I have a table that tracks location by id along with dates a devices was issued and the product/accessory that has been associated to the device. The location can only have 1 device at a time, and the ...
- 23
0
votes
0
answers
25
views
Create a field that counts and groups "chains" of dates within +/- 3 days of each other in SQL. (Translate from PEEK function in QlikSense)
New to SQL and trying to translate a QlikSense calculation into Snowflake SQL
I have a dataset ordered by date/timestamp where I am trying to group dates that fall within 3 days of each other into &...
1
vote
2
answers
56
views
Calculate Beginning and Ending Balances Using R
I am trying to follow a process where I make a contribution to an investment every period, that investment grows or shrinks over time and then I have an ending balance. The next period I take that ...
- 21
2
votes
1
answer
103
views
Roblox Physics Calculation Lag
In my roblox game, you use a rocket launcher to destroy parts, but when a large amount of parts are being calculated at the same time, it causes immense lag to all physics-based items (including ...
- 384
1
vote
0
answers
46
views
How can I resolve lag while writing Spring Boot with Eclipse?
I am a student majoring in coding in South Korea.
As shown in the picture, I am writing code using Spring Boot, but the message 'computing...' keeps popping up and the program lags...
It doesn't even ...
- 11
1
vote
1
answer
26
views
imputing NA with combination of previous values without loop
continuing on last question, i need to impute missing last couple of years as combination of previous years in R. In the data below, i need to impute 2020 as linear combination of 2019,2018 and 2017, ...
- 13
1
vote
3
answers
51
views
Nested for loop alternative for comparing a value to the value of previous year for each ID
I have a data frame with 45k+ rows with the values of a variable SE441 by ID NUM_EXPLOTACION and year ANO.
I want to calculate the difference of the variable for every ID between every year and the ...
- 13
0
votes
1
answer
70
views
Game lags, what is wrong?
The white square lags when it moves. I do not see anything wrong with the code and since the application is very simple, i don't think the hardware is the issue either.
Video demonstrating the issue: ...
- 27