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.
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?