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.