## Google sheets: how to create a grouped per-30-day total without filling thousands of cells?

I have a google spreadsheet that counts a number of events that happened per day. This is what it currently looks like:

I would like to have a 30-day total running alongside, i.e., the total events for every 30 days. It would look something like this:

Here, U7 consists of the sum of the first 30 events (T7:T36), U8 is the sum of the next 30 (T37:T66), U9 sums the next 30 and so on.

I can quite easily do this by filling all of the cells in column U with:

=SUM(OFFSET(\$T\$7,30*(ROW()-7),0,30,1))

but this means every cell has to be filled and it is a bit slow in the scheme of this spreadsheet, particularly as I will need numerous columns like this. Is there a way to do this with a single filter in the top cell or something of the sort? I haven’t been able to figure out a way to do that.

## magento2 – Magento 2 – Get simple products from grouped product

I figured it out. Found the answer in this file:

vendormagentomodule-grouped-productBlockProductViewTypeGrouped.php

``````public function getAssociatedProducts()
{
return \$this->getProduct()->getTypeInstance()->getAssociatedProducts(\$this->getProduct());
}
``````

## pandas groupby – How to set conditions for groups when grouped by several columns in Python?

I have a DataFrame grouped by atc, product_name, strength and form as shown in the attached screenshot. I would like the code to return groups where there are more than 1 unique substitution group.

grouped DataFrame

I have tried the below code but it also returns groups where there is only 1 unique group:

``````df.loc(df.groupby(('atc','product_name','strength','form'))('substitution_group').apply(lambda x: len(x.unique()) >= 2))
``````

Furthermore, the Groupby does not put identical names and strengths into one group but makes several. Is there a solution to this?

## postgresql – Selecting only rows where one ID has the highest value of one field, grouped by two ID’s

It is given in the problem that occurrences has to happen more than once, but the Person(PID) should only be selected with the (Agent)AID having the highest BustCount.

``````SELECT I.AgentID, I.PersonID, Count(*) AS BustCount
FROM InvolvedIn I
WHERE I.AgentID IS NOT NULL
AND I.isCulprit = TRUE
GROUP BY I.AgentID, I.PersonID HAVING COUNT(*) > 1;
``````

This what I get

``````AID     PID     BustCount
1       11      4
2       22      2
3       22      5
4       33      5
5       44      4
``````

But I would like to get only the PID with the highest BustCount ( Not line row 2 )

``````AID     PID     BustCount
1       11      4
3       22      5
4       33      5
5       44      4
``````

## Trying to join 2 tables to get a count of orders and grouped by email

I have two tables in DB Orders with columns Orders Id, Orders NO, Customer ID; Customer with columns Customer ID, Customer email. I need a count of the orders for each customer and group by email with output something like

customeremail@email.com 23

``````SELECT Customer.Customer Email,
Count Orders.Order ID,
From Orders,
Left Join Orders on Customer.Customer ID
Group by Customer.Customer email, Orders.Order ID
``````

## descriptive statistics – What’s the uncertainty on the standard deviation for grouped data?

Suppose I have $$n$$ data points grouped in classes of amplitude $$A$$, say for $$n=10$$ and $$A=5$$ something like this:

Interval Number of points
[0, 5[ 2
[5, 10[ 4
[10, 15[ 1
[15, 20[ 3

and that’s all I know about the data. I want to compute the mean and standard deviation. If I use the middle of the classes to compute the mean:
$$hatmu = frac{2times 2.5 + 4times 7.5 + 1times 12.5 + 3times 17.5}{10} = 10$$
I obtain a value $$hat mu$$ such that the real mean is within A/2 of the actual mean. In other words, the uncertainty on $$mu$$ is $$A/2 = 2.5$$: I know the actual mean is somewhere between $$7.5$$ and $$12.5$$.

My question: if I compute the standard deviation $$hatsigma$$ using again the center of the classes, can I similarly estimate the uncertainty on $$sigma$$, the actual standard deviation?

## ios – Music on iPhone/iPad grouped bizarrely despite being fine on iTunes

I have some ‘albums’ in my iTunes library that look fine to me:

However, when I sync them to my phone and iPad, they become grouped in really weird ways:

If I play the album, all the songs are actually on the device:

I just can’t see them in the actual listing.

I thought it might be the “Grouping” field in iTunes, but it’s empty for all the songs, and the behaviour persists (even after several of the files have been replaced).

How do I get my devices to show me all my songs, not these weirdly grouped swap ins? I’m on Windows, if it makes a difference.

## Is it possible to search Gmail for grouped messages?

I have a number of automated processes that send email reports. One of these reports is sending duplicate messages, which get caught by the Gmail conversation grouping and stacked appropriately. To find other occurrences of this, I’d like to be able to search for all messages that have a grouping greater than 1 that also match other search parameters. I haven’t been able to find anything like this in the Gmail documentation, but I’ve found that’s not always the best indicator of whether or not a specific feature does or doesn’t exist. So…does this exist, either as an explicit keyword, or as some combination of other search terms?

## magento2.3 – How to use grouped product attributes for simple products in layered navigation

I am working on a chemical catalog and I have created grouped products to add attributes like molecular weigt, CAS-Number and other chemical data. These data are all the same for my simple products.
In the layered navigation the grouped products are displayed with its attributes.
What I want now is, that when I click on the layered navigation option, my simple products are displayed too. Untill now, I see only my grouped product.

Therefore my question:
Is there a way to use my grouped attributes to select also my simple products?

Thanks Chris

## 8 – How can I make a slider block with nodes grouped by letter?

I need to make a block that list all nodes of a content type grouped by the first letter of the title. This block should be a slider so the user can iterate by letter. Also, it should have an alphabet filter so the user can filter by letter.

Something like that:

I can make a block with nodes grouped by the first letter of the title.

But how can I convert this to a slider block? And also, how can I make an alphabet filter?