PIWIK Calculated metrics


I would like to inquire if it is possible to obtain the technical formulas for Piwik metrics, such as Pages View, Events, Sessions, and Users …, using the hardcoded fields, without having to go through the column_id. I would greatly appreciate any assistance you can provide.

Thank you in advance.

Best regards,
Maha Lazrak

Hi @maha_lazrak,

Could you please explain in details a bit more about the use case and why it’s necessary?

Hello Adam,

I am currently working on a Qlik Sense project and I need to create some dashboards to visualize Piwik data. They have asked me not to use calculated metrics (such as sessions, users, etc.) and instead calculate them using native fields (like session_id, user_id, etc.). However, I cannot find the rules in the documentation. Could you please let me know if it is possible to do this or if I have no other option but to use calculated metrics?

Thank you.

Hi @maha_lazrak,

Unfortunately, the only way to proceed with it is to use calculated metrics

Okey ! thank you so much !!