Skip to Content
Menu
This question has been flagged

This solution demonstrates how to create specific, real-time, and interactive charts for each client in Odoo, for this example we are making use of Looker Studio and Google Sheets.


We should follow the following steps:


1. Firstly, create a table with relevant information in Google Sheets and link it to our Looker Studio report, as shown in the attached photograph.


2. Next, decide on the types of charts to display in Looker Studio based on the client's requirements. Options include pie charts, bar graphs, dynamic tables, etc.


3. Then, go to the website application and create a new page. During this process, ensure that the page is not displayed in the menu.


4. On this page, add a embed code building block. 


5. Copy the code from Looker Studio by clicking the share button, choosing the 'Embed Report' option, and then 'Copy to Clipboard'.


6. Now, on the website page, select 'Edit HTML' (the green button in the editing menu). Delete the current code and paste the code copied from Looker Studio, as shown in the next image.



7. After saving, the interactive charts will be visible on this web page.


8. Then, take the link of the page and create a project and a task named "reports". Assign the project to the client. In the task description, include a button linked to the web page. This allows the client to access the charts directly from their project task portal by clicking the button, which redirects them to the page with their charts.


As the created page is not displayed in the menu, it will only be accessible to those with the link. Therefore, we also provide direct access through the button.

Avatar
Discard
Related Posts Replies Views Activity
2
Jan 18
7126
0
Sep 15
4718
0
Aug 24
3060
2
Aug 24
3853
0
Mar 21
3147