# Cumulate Data in Data Studio **URL:** \ **Category:** API & integrations\ **Created:** [August 22, 2022, 8:39am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914 "2022-08-22T08:39:59Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Susanne](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/susanne/32/4406_2.png) [@Susanne](https://community.piwik.pro/u/Susanne)\ **Post date:** [August 22, 2022, 8:39am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/1 "2022-08-22T08:39:59Z")
Hello. I have already asked this in a [Support Ticket](https://support.piwik.pro/support/tickets/21154) but I was wondering if I find a different answer or creative approach in the Community 🙂 * * * I connected Data Studio with Piwik PRO and am currently updating our existing Dashboards with the new Data from Piwik (we used Google Analytics Data before) Now I have several cases where Data is not shown cumulated: How it is: August 2022 is shown in several rows ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/c966d8d66379e550098fd540d57439eb06a0c207.png) How it should be (Screenshot with Data from GA): one Row with August 2022, one with July 2022 ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/9538a259e9c7297d60d5b6445c1ffa3c8d00a555.png) It is a Blended Data Source where I use "campaign name RegExp Contains .\* to define the selection “UTM campaign is set” ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/410420e62c76611e9a32370f029c435f860019ee.png) Now I guess I get one row per UTM campaign as there might be various campaigns. Thanks, Susanne ---
**Author:** ![kuba](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/kuba/32/7_2.png) [@kuba](https://community.piwik.pro/u/kuba)\ **Post date:** [August 23, 2022, 8:12am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/2 "2022-08-23T08:12:13Z")
Hi. This issue will be addressed in the new version of data studio connector. You can expect it within 2 weeks from now. ---
**Author:** ![Serena](https://avatars.discourse-cdn.com/v4/letter/s/a87d85/32.png) [@Serena](https://community.piwik.pro/u/Serena)\ **Post date:** [September 13, 2022, 10:52am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/3 "2022-09-13T10:52:39Z")
Hi Kuba, has the new version of data studio connector been released which can solve this problem? Where I can find it? Thank you. Best, Serena ---
**Author:** ![Piotrek](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/piotrek/32/160_2.png) [@Piotrek](https://community.piwik.pro/u/Piotrek)\ **Post date:** [September 13, 2022, 12:19pm UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/4 "2022-09-13T12:19:39Z")
Hello @Serena, We released a new version of the connector that improves filters. You will find the latest version in our Help Center article: [Looker Studio (Google Data Studio) integration | Piwik PRO help center](https://help.piwik.pro/support/integrations/google-data-studio-integration/) Keep in mind that it’s not possible to use the “partial RegExp matches” operator with our data, because we don’t provide an operator like that in our product (only exact matches). ---
**Author:** ![Serena](https://avatars.discourse-cdn.com/v4/letter/s/a87d85/32.png) [@Serena](https://community.piwik.pro/u/Serena)\ **Post date:** [September 14, 2022, 9:59am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/5 "2022-09-14T09:59:06Z")
Hi Piotrek, thanks a lot for your answer. We tried it today but the problem doesn’t seem to be solved. Look here (with the new data connector as source): ![MicrosoftTeams-image (1)](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/fd10b09993da62566788a3c7352dc513ac13e72e.png) We still have the data not summed up. Can you help us to solve this problem please? Thank you ---
**Author:** ![Susanne](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/susanne/32/4406_2.png) [@Susanne](https://community.piwik.pro/u/Susanne)\ **Post date:** [September 20, 2022, 9:17am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/6 "2022-09-20T09:17:18Z")
Hello! Adding to Serenas Input (we are in the same team), I have now used the new Connector in an existing Dashboard and encountered the following error: When I use a global filter for the report (eg Filter by page URL), I get a Data Set Configuration Error ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/46c4d9310bd81096cafc7f0aefe73e4431f80ba0.png) Do you have any Info on how to avoid this? Thanks, Susanne ---
**Author:** ![Serena](https://avatars.discourse-cdn.com/v4/letter/s/a87d85/32.png) [@Serena](https://community.piwik.pro/u/Serena)\ **Post date:** [October 7, 2022, 10:11am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/7 "2022-10-07T10:11:54Z")
Hi @Piotrek , do you know when will the next Connector release (after that of 14.09) be? Thanks. Best, Serena ---
**Author:** ![dave](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@dave](https://community.piwik.pro/u/dave)\ **Post date:** [October 7, 2022, 7:18pm UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/8 "2022-10-07T19:18:51Z")
Same issue here, tried to aggregate the days into months in several ways but it keeps showing day/day data. A solution would be handy 🙂 ---
**Author:** ![Susanne](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/susanne/32/4406_2.png) [@Susanne](https://community.piwik.pro/u/Susanne)\ **Post date:** [November 3, 2022, 8:24am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/9 "2022-11-03T08:24:21Z")
Hello @Piotrek. Is there any news on this? Also, the Connector from 14.9. does not allow any filters. Do you have News about a possible date for a new one which fixes those issues? Thanks for letting me know. Susanne ---
**Author:** ![Piotrek](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/piotrek/32/160_2.png) [@Piotrek](https://community.piwik.pro/u/Piotrek)\ **Post date:** [November 3, 2022, 10:25am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/10 "2022-11-03T10:25:04Z")
Hello @Susanne, The latest version supports filters - it’s linked in our Help Center article: [Looker Studio (Google Data Studio) integration | Piwik PRO help center](https://help.piwik.pro/support/integrations/looker-studio-integration/). We’re currently looking into adding better aggregations to months in the connector. We don’t have a release date yet, but in general we are planning two releases this month (one in the first half of November and one in the second half) and we want to include a solution in one of them. ---
**Author:** ![Susanne](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/susanne/32/4406_2.png) [@Susanne](https://community.piwik.pro/u/Susanne)\ **Post date:** [November 3, 2022, 10:29am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/11 "2022-11-03T10:29:58Z")
Great, thanks! Could you please let me/us know in this thread, when also the cumulation topic is fixed? So we can come back to it and get the latest connector. Thanks, Susanne ---
**Author:** ![Piotrek](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/piotrek/32/160_2.png) [@Piotrek](https://community.piwik.pro/u/Piotrek)\ **Post date:** [November 28, 2022, 10:27am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/12 "2022-11-28T10:27:57Z")
Hello @Susanne, We have just released a new version of our Data Studio connector which includes a fix for the issue with dimension value duplicates. Data that you see in charts and reports should not contain duplicates anymore. You can find the latest version in our Help Center article: [Looker Studio (Google Data Studio) integration | Piwik PRO help center](https://help.piwik.pro/support/integrations/looker-studio-integration/) More info about what happened an how we fixed it: the issue was a result of a change introduced by Google to the data model provided by connectors like ours. We have implemented changes to our schema based on feedback from Google and as a result, all metrics and dimensions will now appear as green fields in the connector. They will look like dimensions, but if you drop them into the metrics section in a chart/table definition, they will switch to a blue field (a metric). Example: ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/5252a34f26a4f259116ecc680672cb273e3aba2c.png) ---
**Author:** ![Susanne](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/susanne/32/4406_2.png) [@Susanne](https://community.piwik.pro/u/Susanne)\ **Post date:** [November 29, 2022, 1:53pm UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/13 "2022-11-29T13:53:01Z")
Hi Piotrek. Amazing news, thanks! I have already tried it and it works, also I found I could easily fix the dimension/metrics mixup as described. So great you guys fixed this. Right now I feel the new connector does not work with filters, could this be the case? When I set a filter i receive an error in the widgets. ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/684bbe62ada58aeaf7f3a1267f4534502cf566f9.png) Thanks, Susanne ---
**Author:** ![dave](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@dave](https://community.piwik.pro/u/dave)\ **Post date:** [November 30, 2022, 2:59pm UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/14 "2022-11-30T14:59:27Z")
@Susanne @Piotrek , how do you aggregate the date field. Did try a few ways but doesn’t seem to work well on my side (updated the connector first) ![2](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/83089ae4ed0d05011aa341fb69f86310c68dd3f5.jpeg) Thxs ---
**Author:** ![Susanne](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/susanne/32/4406_2.png) [@Susanne](https://community.piwik.pro/u/Susanne)\ **Post date:** [December 1, 2022, 12:50pm UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/15 "2022-12-01T12:50:38Z")
Hello dave.It works for me with these settings: ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/4802bb42b307752ce8b9c7b52725676476189523.png) ---
**Author:** ![dave](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@dave](https://community.piwik.pro/u/dave)\ **Post date:** [December 21, 2022, 11:53am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/16 "2022-12-21T11:53:34Z")
@Susanne totaly missed this one 😕 So strange since i’m using the same but it doesn’t aggregate. ![1](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/4/4004302487109fcde632548ee99d685454ab3915.png) Any idea what can go wrong @Piotrek ? Even a simple bar chart seems very messed up and showing up in a random order ![1](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/6/65aa563d89f31a39feb67ee9eac270ed7506c8fa.png) Thxs ---
**Author:** ![Martin](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@Martin](https://community.piwik.pro/u/Martin)\ **Post date:** [August 8, 2024, 8:37am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/17 "2024-08-08T08:37:58Z")
For everyone that still has the problems with cumulated data in Looker Studio. When using a default metric like unique pageviews and you want to see the views per weekday, you will still get the error shown above: ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/c/c0675e4ec82c1289a1f68340a3c57b6a33e397ce.png) You have to use the SUM() function in a custom field ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/a/a0ad96d6ceade106cea0ca358a7f85471f865c21.png) This way the graphs show the data cumulated. Knowing that its a no brainer, but there are some solutions on the web with formulas that do not work. ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/3/34e4fddd84fb33042baa31388a2c2d62d3f98f35.png) ---
**Author:** ![Martin](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@Martin](https://community.piwik.pro/u/Martin)\ **Post date:** [September 9, 2024, 11:26am UTC](https://community.piwik.pro/t/cumulate-data-in-data-studio/914/18 "2024-09-09T11:26:58Z")
Edit, does not work for Sessions. Sessions are counted for each single day.