Inconsistency: calculated daily Tx Fee vs the charted one

[phroi]

Hello Explorer Folk,

looking at the tx fee chart, explained as Total transaction fees charged by miners, I noticed a spike of almost 500k CKB in fees on the 2024/7/31. Removing the logarithm scale makes it evident how much of an outlier it really is.

So I went to calculate it manually using txs_fee in get_block_economic_state for each block in that day and I got:

• ~ 110 CKB payed in total in tx fees in that day
• ~ 58 CKB payed in this particular tx as fee

Basically I'm unable to reproduce the Explorer chart results.

Could you explain the inconsistency ?

Love & Peace, Phroi

[Keith-CY]

Hi @phroi thank you for sharing this.

@poor-defined do you have time for this case?

[poor-defined]

Hi @phroi thank you for sharing this.

@poor-defined do you have time for this case?

Yes, I will check it.

[poor-defined]

Hi @phroi ,
We found that in block 13653520, a transaction paid a significant transfer fee, leading to such a peak in tx fee chart.

cc @Keith-CY

[phroi]

Man, these days people don't really know how to spend their CKB!! 🤣

@poor-defined good to know, thank you!! By the way, that tx did not appear in my data because is date on 2024/08/01 21:33:19, definitely didn't happen on the 2024/07/31.

Could you explain why is it charted under the 2024/07/31?

[phroi]

[poor-defined]

Man, these days people don't really know how to spend their CKB!! 🤣

@poor-defined good to know, thank you!! By the way, that tx did not appear in my data because is date on 2024/08/01 21:33:19, definitely didn't happen on the 2024/07/31.

Could you explain why is it charted under the 2024/07/31?

Yep, crazy, man.

And about the date issue, I believe this is a mistake caused by time scaling as you can see on the x-axis.

There're too many dates on the x-axis ,so the x-axis is compressed. The displayed date when you hover your mouse is not the exact date of the Transaction Fee. I think the displayed date without zooming in is just included the date period where the maximum value occurred but not the exact day of when it happens.

If we narrow the range on x-axis, we can see this value positioned correctly on the right date.

[phroi]

And about the date issue, I believe this is a mistake caused by time scaling as you can see on the x-axis.

Nope, not scaling as you can see, maybe different timezone so they get bucketed in different days?

I'm noticing how in your graph is correct, while in mines are not! Currently I'm in Vietnam and using Brave if it helps.

[poor-defined]

And about the date issue, I believe this is a mistake caused by time scaling as you can see on the x-axis.

Nope, not scaling as you can see, maybe different timezone so they get bucketed in different days?

I'm noticing how in your graph is correct, while in mines are not! Currently I'm in Vietnam and using Brave if it helps.

Oh, maybe, I will mark it first and we will correct it in asap, thank you bro :)

[phroi]

No worries!! If you plan on fixing it, once you have a fix feel free to ask me to double check it. Otherwise it's also okay to leave it like it is and just close the issue. Your call!

Phroi