根据15分钟间隔的计数添加记录 [英] Add records depending on count of 15 min interval

问题描述

大家好，


是否可以使用函数或查询，将记录分组15分钟，计算此区间中有多少条记录并添加这些记录的百分比（例如5％）记录以提升金额。我尝试了不同的方法，但似乎都没有。


谢谢

Gareth

解决方案

< blockquote>取分钟，计算该数字的mod 15，从该值中减去那么多分钟。按此新字段分组。

感谢您的回答。有没有办法在群众中做到这一点？我在OP中并不是很清楚，因为有大约800k的记录。


谢谢

我描述的算法是集体运作的。这只是一个公式，我并不是说你必须手工计算它。

Hi all,

Is it possible using a function or query, to group records by 15 minutes, count how many records there are in this interval and add a percentage of these (e.g. 5%) records to uplift the amount. I have tried a different methods however none appear to be working.

Thanks
Gareth

解决方案

Take the minutes, calculate the mod 15 of that number, subtract that many minutes from the value. Group by this new field.

Thanks for answering. Is there a way of doing this on mass? I wasn''t very clear in the OP, as there are approx 800k records.

Thanks

The algorithm I described works en masse. It''s just a formula, I didn''t mean you had to calculate it by hand.

这篇关于根据15分钟间隔的计数添加记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！