duplicates

[Jan Turner]

I have a Looker Studio table that uses a single Google Sheet. The  Looker Studio table is automatically removing rows that are duplicates. Is there a way to not have the duplicate removed but display both in Looker Studio?

Thanks,

Jan

                                                           

Janet Heys Turner
Technology Reporting Specialist
Town of Franklin/Franklin Public Schools
355 East Central Street
Room 219
Franklin, MA 02038
(508) 553-4845
(508) 520-3372 Fax
tur...@franklinps.net

-------------------------------------------------------

This email is intended for municipal / educational use only and must comply with the Town of Franklin and Franklin Public School's policies and state/federal laws. Under Massachusetts Law, any email created or received by an employee of The Town of or Franklin Public Schools is considered a public record.  All email correspondence is subject to the requirements of M.G.L. Chapter 66. This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies.

-------------------------------------------------------

This email is intended for municipal / educational use only and must comply with the Town of Franklin and Franklin Public School's policies and state/federal laws. Under Massachusetts Law, any email created or received by an employee of The Town of or Franklin Public Schools is considered a public record.  All email correspondence is subject to the requirements of M.G.L. Chapter 66. This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies.

[Bucky Bush]

Jan,

I'm not sure if there is a better way but I would add a field to the Google Sheet that has a unique value for each row - something like this would work: =ARRAYFORMULA(Row(A2:A). If you use that field in your Looker Studio table, it will deduplicate your data. You would need additional code in the formula to only add a row number when data exists in the row.

Bucky Bush Technology Director 📞 706-295-6189 x 139 Equip, Empower, and Serve Educators

--
You received this message because you are subscribed to the Google Groups "Data Studio in Education" group.
To unsubscribe from this group and stop receiving emails from it, send an email to googleschool-data...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/googleschool-datastudio/CAMwFEOgHeDok0ebTxtKK_PupzU6g7B4f3Hrq9hK-N2n7JUx28A%40mail.gmail.com.

[Jan Turner]

Thanks,

Jan

To view this discussion visit https://groups.google.com/d/msgid/googleschool-datastudio/CAP64YmpsePfK7JW3Q-16q%3D%3DuLzLNLjHMhmx_K%3DhpjnnM3fT99g%40mail.gmail.com.

[Brett Gimlin]

That was my thinking exactly. 

Here is a formula that only adds a row number when there is data in the A column: =ARRAYFORMULA(IF(LEN(A2:A), ROW(A2:A), ""))

To view this discussion visit https://groups.google.com/d/msgid/googleschool-datastudio/CAP64YmpsePfK7JW3Q-16q%3D%3DuLzLNLjHMhmx_K%3DhpjnnM3fT99g%40mail.gmail.com.

--

-Brett Gimlin

Director of Curriculum Programs, Student Success

Lucia Mar Unified School District

Arroyo Grande, CA 93420

This is a staff email account managed by Lucia Mar Unified School District.  This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify the sender.

[Laura Tilton]

Alternatively, you could also add a Record Count column to your table. It wouldn't display the row twice, but would at least show that the row appears twice in your data.

Laura

On Mon, Dec 2, 2024 at 12:45 PM Jan Turner <tur...@franklinps.net> wrote:

--

[Sara Hoffman]

Hi,

Check the Data Source Setting in Looker. Go to the Edit Data Source menu (click on the little pencil next to the data title in your Looker) For each column, make sure that Aggregation is set to None. If it's set to Sum or Average, remove the metric to show each row. 

Sara

On a side note, how do you all pronounce "Data"? Do you pronounce it with a long A (dayta) or a short A (dahta). Just curious. 

[OHayer, Sean]

I’ve always pronounce it DAY-ta.  Thanks, Goonies!

 

 

Sean O’Hayer

Network Support Specialist

Homestead High School

2526

 

Need tech help?  

STAFF, please OPEN A HELP TICKET!

 

STUDENTS and PARENTS, please use the Student Tech Help Form.

--
You received this message because you are subscribed to the Google Groups "Data Studio in Education" group.
To unsubscribe from this group and stop receiving emails from it, send an email to googleschool-data...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/googleschool-datastudio/d51b1f75-7fce-42f5-826f-e3f70ffe6bcan%40googlegroups.com.

[James Hatz]

There is only one correct way to pronounce Data .. source: 

https://www.youtube.com/watch?v=F2e0KbUohh8

--
You received this message because you are subscribed to the Google Groups "Data Studio in Education" group.
To unsubscribe from this group and stop receiving emails from it, send an email to googleschool-data...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/googleschool-datastudio/d51b1f75-7fce-42f5-826f-e3f70ffe6bcan%40googlegroups.com.

[Hoffman, Sara]

Love it!!! 

You received this message because you are subscribed to a topic in the Google Groups "Data Studio in Education" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/googleschool-datastudio/zLKnnUrvc44/unsubscribe.
To unsubscribe from this group and all its topics, send an email to googleschool-data...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/googleschool-datastudio/CAOGTeFEiR4Y8Np-z15RjOfxTzKvE85E18tCq1DRn8kqwi%3Dwfjg%40mail.gmail.com.

--

🗓️ Schedule an appointment with me! 

💻 See all of the district's digital learning resources HERE. 

[Jan Turner]

Thanks, Sara, unfortunately the aggregation was already set to none.

Jan

--
You received this message because you are subscribed to the Google Groups "Data Studio in Education" group.
To unsubscribe from this group and stop receiving emails from it, send an email to googleschool-data...@googlegroups.com.

To view this discussion visit https://groups.google.com/d/msgid/googleschool-datastudio/d51b1f75-7fce-42f5-826f-e3f70ffe6bcan%40googlegroups.com.

[Hoffman, Sara]

Shoot, I'm stumped then. I have OST data in a Looker and the students are listed multiple times for the multiple tests they took. 

I use ChatGPT to help with looker questions a lot. They have a specific GPT for Looker Studio

You received this message because you are subscribed to a topic in the Google Groups "Data Studio in Education" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/googleschool-datastudio/zLKnnUrvc44/unsubscribe.
To unsubscribe from this group and all its topics, send an email to googleschool-data...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/googleschool-datastudio/CAMwFEOhWRy24uQLXhvVwZ4Xbb467F3R-TPurEsdd282-71V2fQ%40mail.gmail.com.

[John LaPlante]

Hey Jan - just a question - what kind of viz are you creating?  

The only reason I ask - I do a ton of work with OST data (I'm in the Youngstown area), and I don't have an issue with duplicates - but it really depends on the type of viz you're building.

For example, if you're building a bar chart, and you choose student as one of the dimensions, then removing the duplicate students is required to build that type of visualization.  If, however, you're building a table, then it won't remove the duplicates - because the table will print all of the data.

I'd be happy to jump on a Google Meet with you if you'd like me to take a look at your setup.  Just let me know.

John

To view this discussion visit https://groups.google.com/d/msgid/googleschool-datastudio/CALDNGDZ1TK2mcgOOQPKsQZUn47MbEAkzaaD8w52pSp2tOr3rBA%40mail.gmail.com.