How to create calculated formula for transactions/second

Q&A
, ,
1

I have the transactions count and the date field. i want to get the daily transactions/second.
meaning having e.g a line graph that show the daily dates, with their total transactions/second for the day.

Date user id transaction count
Feb 11, 2024 12:00:00 AM xxxx 1
Feb 11, 2024 12:00:01 AM yyyy 1
Feb 11, 2024 12:00:02 AM qqqq 1
Feb 11, 2024 12:00:03 AM 2222 1
Feb 11, 2024 12:00:04 AM 111 1
Feb 11, 2024 12:00:05 AM 333 1

i have tried sumOver and periodToDateAvgOverTime. but both didnt result in that.

2

HI @linndaa
what exactly did you do so far?
Maybe you can try:

sumOver(sum({transaction count}),[extract("DD", {date})])

BR

3

this doesnt work.
i want to show the information as shown below:

Date(day) transactions/second
23-02-2024 12
24-02-2024 14.23
25-02-2024 12.01
26-02-2024 13.33

but my initial table only have transactions count and the data timestamp. How can i have such that i can divide the transactions by the total secconds of the aggregated date e.g. day.

so far all formulas return the total transactions for the day.

4

For you sample
grafik

you would like to have the result:

Date(day) transactions/second
11-02-2024 6

Or could you give us an input and output sample?