mark | 一个还算简洁的双栏主题 | Theme library

Unpivot, sort, pivot with conditional aggregation

My advice would be: don't try this in a playground. Playgrounds aren't ready for this stuff yet. Your code compiles and runs fine in a real project. Here's an example:

As given in this answer, Storms Internal Metrics are just estimated by a percentage of the real data flow. Initially, it uses 5% of incoming tuples to make those estimations. This may lead to inaccuracies for extreme high or low throughputs.

EDIT: The documentation describes the following:

In general all of these tuple count metrics are randomly sub-sampled unless otherwise stated. This means that the counts you see both on the UI and from the built in metrics are not necessarily exact. In fact by default we sample only 5% of the events and estimate the total number of events from that. The sampling percentage is configurable per topology through the topology.stats.sample.rate config. Setting it to 1.0 will make the counts exact, but be aware that the more events we sample the slower your topology will run (as the metrics are counted in the same code path as tuples are processed). This is why we have a 5% sample rate as the default.

EDIT 2 In this post, there is more information about the estimation:

The way it works is that if you choose a sampling rate of 0.05, it will pick a random element of the next 20 events in which to increase the count by 20. So if you have 20 tasks for that bolt, your stats could be off by +-380.

By the way, execute_count is just an increasing number, while your tuple_inRate.count is a rate, isn`t it?

Updated formula:

=IF(VALUE(VLOOKUP($A2, Master!$A:$M, 13, 0)) > VALUE(VLOOKUP($A2, Master!$A:$M, 12, 0)), IF(ISBETWEEN(B$1, VALUE(VLOOKUP($A2, Master!$A:$M, 12, 0)), VALUE(VLOOKUP($A2, Master!$A:$M, 13, 0))), "Y", "N"), IF(OR(B$1 <= VALUE(VLOOKUP($A2, Master!$A:$M, 13, 0)), B$1 >= VALUE(VLOOKUP($A2, Master!$A:$M, 12, 0))), "Y", "N"))

Screenshot from the sheet you've shared with the formula working:

This version is an extension of the formula you shared. If someone is working from 4PM to 2AM then the way IFBETWEEN is being used will throw an error because 2AM is numerically less than 4PM and hence there is nothing in between.

So in cases where someone starts at a PM time and ends at AM time the formula checks for all slots between 12AM and the person working AM and marks them a Y. At the same time the formula also checks for all times in PM that are greater than the person working PM and marks them a Y as well.

If the person starts at a PM time and ends at a greater PM time then it uses your initial version of the formula.

I have made a slight modification to your formula and it should work now.

=IF($C9>$B9, IF(ISBETWEEN(B$1, VLOOKUP($A2, $A$8:$C, 2, 0), VLOOKUP($A2, $A$8:$C, 3, 0)), "Y", "N"), IF(OR(B$1 <= VLOOKUP($A2, $A$8:$C, 3, 0), B$1 >= VLOOKUP($A2, $A$8:$C, 2, 0)), "Y", "N"))

Please remember to remove the dates from some of the cells ex in your sheet the value in C2 is 12/31/1899 2:00:00 and it should be changed to just 2:00:00.

There are two problems which are causing the counter not to be incremented.

The first is that the CSS:

Since your example is a JS array and no JSON string, you can use map:

const result = data.map(d => { return {Name: d.name, Value: d.Value }});

You're gonna have to get the TextChannel instance first, then you can either use the fetch_message or get_partial_message method