# Piwik & Looker Studio - Breakdown per month **URL:** \ **Category:** Data collection and tags\ **Created:** [July 5, 2023, 11:53am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538 "2023-07-05T11:53:43Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![ValPiwik](https://avatars.discourse-cdn.com/v4/letter/v/ecd19e/32.png) [@ValPiwik](https://community.piwik.pro/u/ValPiwik)\ **Post date:** [July 5, 2023, 11:53am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/1 "2023-07-05T11:53:43Z")
Hello, I’m trying do to a basic report on looker studio with Piwik. ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/2/2a00510cfc6f7c2f2ab92dfa5e1f4475b3c35849.png) I want a breakdown per month. But, as you can see, it doesn’t work very well… I tried also to choose “month” as dimension, but it changes nothing. Many thanks, ---
**Author:** ![Ralf](https://avatars.discourse-cdn.com/v4/letter/r/c89c15/32.png) [@Ralf](https://community.piwik.pro/u/Ralf)\ **Post date:** [July 5, 2023, 1:27pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/2 "2023-07-05T13:27:05Z")
You’re using a stacked column chart. I think you should use a time series chart and change styling to bars. BUT: this doesn’t solve the problem. Using drill down to Year/Month will display only the last day of any month but it should sum up per month. ![piwik month drill down](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/9/910c4f7954e3b04201e39587a389fa38a66db067.jpeg) ![piwik month drill down2](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/3/3423c7738928b3ec4f0a251adceebcb1f5e7717c.jpeg) So many thank if someone could fix it! Best Ralf ---
**Author:** ![ValPiwik](https://avatars.discourse-cdn.com/v4/letter/v/ecd19e/32.png) [@ValPiwik](https://community.piwik.pro/u/ValPiwik)\ **Post date:** [July 5, 2023, 1:34pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/3 "2023-07-05T13:34:47Z")
If I create a line chart and switch the line in bar, it works. But, next I add the breakdown per channel and I get the following error: Error ID: 8c3ab746 ---
**Author:** ![dave](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@dave](https://community.piwik.pro/u/dave)\ **Post date:** [July 5, 2023, 3:28pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/4 "2023-07-05T15:28:10Z")
You can but use date as dimension and change type to Year Month ![snip](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/0/0d42d09237a4a709792b77a522ae2b29063bccb0.png) ---
**Author:** ![Ralf](https://avatars.discourse-cdn.com/v4/letter/r/c89c15/32.png) [@Ralf](https://community.piwik.pro/u/Ralf)\ **Post date:** [July 5, 2023, 4:09pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/5 "2023-07-05T16:09:48Z")
dave, I don’t get it. What I’m doing wrong? ![KPI-Dashboard-Piwik-Pro](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/7/716173ba3a6d58030666bf36b77363d4a8adf142.png) thx ---
**Author:** ![dave](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@dave](https://community.piwik.pro/u/dave)\ **Post date:** [July 5, 2023, 6:59pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/6 "2023-07-05T18:59:19Z")
Doesn’t look like you’re using sum for the pv’s? ![snip](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/b/bae5e5c311c90786ae0f5418d062eed8483e2d12.png) ---
**Author:** ![ValPiwik](https://avatars.discourse-cdn.com/v4/letter/v/ecd19e/32.png) [@ValPiwik](https://community.piwik.pro/u/ValPiwik)\ **Post date:** [July 6, 2023, 6:29am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/7 "2023-07-06T06:29:36Z")
This morning it works: so I assume that the connector doesn’t work all the time… More problematic, the data displayed are completely wrong… Data in Looker Studio: ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/b/b0378f8adc835704e86b9f9669d043b7633ef27d.png) Same report, same metrics, dimensions & filters in Piwik: ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/2/298b49c9f537362175e513fc195c8632c2e956a2.png) ---
**Author:** ![Ralf](https://avatars.discourse-cdn.com/v4/letter/r/c89c15/32.png) [@Ralf](https://community.piwik.pro/u/Ralf)\ **Post date:** [July 6, 2023, 7:20am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/8 "2023-07-06T07:20:56Z")
@dave interesting. I don’t get the option to change aggregation for standard field “Page views”. ![sum pageviews](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/1/1a386b7796e69b674198f06e8e40e8301e5c174f.jpeg) My solution for this is a custom field, called “Page views (sum up)” as calculated field: SUM(Page views) and this works, but it’s a workaround for me. ---
**Author:** ![ValPiwik](https://avatars.discourse-cdn.com/v4/letter/v/ecd19e/32.png) [@ValPiwik](https://community.piwik.pro/u/ValPiwik)\ **Post date:** [July 7, 2023, 9:27am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/9 "2023-07-07T09:27:55Z")
Any comment from Piwik regarding this issue? ---
**Author:** ![dave](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@dave](https://community.piwik.pro/u/dave)\ **Post date:** [July 11, 2023, 2:19pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/10 "2023-07-11T14:19:04Z")
weird… but if it’s working = problem -1 🙂 ---
**Author:** ![ValPiwik](https://avatars.discourse-cdn.com/v4/letter/v/ecd19e/32.png) [@ValPiwik](https://community.piwik.pro/u/ValPiwik)\ **Post date:** [July 11, 2023, 2:39pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/11 "2023-07-11T14:39:47Z")
Well, nothing works in my case… ---
**Author:** ![asinior](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/asinior/32/1905_2.png) [@asinior](https://community.piwik.pro/u/asinior)\ **Post date:** [July 12, 2023, 8:21am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/12 "2023-07-12T08:21:19Z")
Hi, We are taking a look at the issue and will update you as soon as we find a solution to that. ---
**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:** [July 12, 2023, 11:06am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/13 "2023-07-12T11:06:11Z")
@ValPiwik which version of the connector are you using? We improved aggregation for those kinds of charts in version 1.0.6. Here’s my example report using the latest 1.0.8: ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/3/3691652f6acfe9010659e20b115c85abeb44714b.png) The data matches what I get in Piwik PRO Analytics: ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/a/ab5b242c02a19bec5ead025ee8ff06353224b92f.png) ---
**Author:** ![Ralf](https://avatars.discourse-cdn.com/v4/letter/r/c89c15/32.png) [@Ralf](https://community.piwik.pro/u/Ralf)\ **Post date:** [July 12, 2023, 11:10am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/14 "2023-07-12T11:10:02Z")
Hi @Piotrek , where do I get the information about which version it is? thx, ralf ---
**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:** [July 12, 2023, 11:21am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/15 "2023-07-12T11:21:43Z")
It’s listed in the connector description here: ![image](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/8/8cd1e32ca8c9e1376fa1a1eefdcf930a535424ea.png) You can update using the link from our article here: [Looker Studio (Google Data Studio) integration | Piwik PRO help center](https://help.piwik.pro/support/integrations/looker-studio-integration/#integrate-piwik-pro-with-looker-studio-(google-data-studio)) ---
**Author:** ![Ralf](https://avatars.discourse-cdn.com/v4/letter/r/c89c15/32.png) [@Ralf](https://community.piwik.pro/u/Ralf)\ **Post date:** [July 12, 2023, 11:25am UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/16 "2023-07-12T11:25:58Z")
@piotrek what I’m doing wrong? ![Looker-Connector-Piwik-Pro](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/e/ecfbfcd3929fde1689c90623302bf249c4bcd093.png) [Edit] I think I got it. I can get it via Link in your website, Looker itself uses the old one. Is there a way to update existing connectors to v 1.0.8? ---
**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:** [July 20, 2023, 1:56pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/18 "2023-07-20T13:56:25Z")
@Ralf sorry for replying late. We describe updating the connector in our docs [here](https://help.piwik.pro/support/integrations/looker-studio-integration/#update-looker-studio-integration). Unfortunately until we are published in Google’s gallery, that needs to be done manually. We’re waiting for a change in our product’s APIs before we can get published, so it might take a couple more months before that’s possible. ---
**Author:** ![Ralf](https://avatars.discourse-cdn.com/v4/letter/r/c89c15/32.png) [@Ralf](https://community.piwik.pro/u/Ralf)\ **Post date:** [July 20, 2023, 2:01pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/19 "2023-07-20T14:01:57Z")
@Piotrek thx for reply. If you make changes to current implementation v 1.0.8 what will happen then? Is it the same procedure for next version? There are several bugs in current implementation as well, or let me say unexpected behaviour. 😉 Do you have any plans for further developments? ---
**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:** [July 20, 2023, 4:15pm UTC](https://community.piwik.pro/t/piwik-looker-studio-breakdown-per-month/2538/20 "2023-07-20T16:15:12Z")
We’re aware of some issues, for example those related to the fact that filters work differently in Looker Studio than in our Analytics. We’re trying to improve the connector step by step and we plan to release further updates. Unfortunately the process would be the same. On the other hand, with the procedure described in the article at least you don’t have to redefine dashboards based on Piwik PRO data when you update from one version to another.