learn to design kpi and query

[pepitovadecurt]

I have problems in designing a report with accounts and analytical accounts.
Can someone recommend me a link or book to learn KPIs and queries with MisReports?

[sbidoul]

There is no book (yet? hehe).

There is a user documentation at https://oca-mis-builder.readthedocs.io/en/10.0/. It can still be improved and contributions are welcome. The source of the doc is in GitHub at https://github.com/OCA/mis-builder/tree/10.0/docs.

Issues with label question can also be a useful source of information.

[pepitovadecurt]

Thanks sbidoul !
I've got what you need with the links.
Obtain a 18% values that have specific analytic account:
bale[18%][('analytic_account_id.display_name', '=', 'name_on_analytic_account')]
disadvantage: the kpi description need to put manually

I use the query more complicated because I can not find any information.

[sbidoul]

Queries is indeed an area of the documentation that needs improvement.

[pahangm]

Queries is indeed an area of the documentation that needs improvement.

please...

[github-actions]

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.