# PIWIK Calculated metrics

**URL:** <https://community.piwik.pro/t/piwik-calculated-metrics/4063>\
**Category:** Data collection and tags\
**Created:** [May 31, 2024, 3:05pm UTC](https://community.piwik.pro/t/piwik-calculated-metrics/4063 "2024-05-31T15:05:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![maha\_lazrak](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/maha_lazrak/32/3447_2.png) [@maha\_lazrak](https://community.piwik.pro/u/maha_lazrak)\
**Post date:** [May 31, 2024, 3:05pm UTC](https://community.piwik.pro/t/piwik-calculated-metrics/4063/1 "2024-05-31T15:05:17Z")

</div>

Hello,

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

---

<div class="post-metadata">

**Author:** ![Adam](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/adam/32/1494_2.png) [@Adam](https://community.piwik.pro/u/Adam)\
**Post date:** [June 3, 2024, 6:06am UTC](https://community.piwik.pro/t/piwik-calculated-metrics/4063/2 "2024-06-03T06:06:55Z")

</div>

Hi @maha_lazrak,

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

---

<div class="post-metadata">

**Author:** ![maha\_lazrak](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/maha_lazrak/32/3447_2.png) [@maha\_lazrak](https://community.piwik.pro/u/maha_lazrak)\
**Post date:** [June 3, 2024, 10:07am UTC](https://community.piwik.pro/t/piwik-calculated-metrics/4063/3 "2024-06-03T10:07:25Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Adam](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/adam/32/1494_2.png) [@Adam](https://community.piwik.pro/u/Adam)\
**Post date:** [June 3, 2024, 10:21am UTC](https://community.piwik.pro/t/piwik-calculated-metrics/4063/4 "2024-06-03T10:21:56Z")

</div>

Hi @maha_lazrak,

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

---

<div class="post-metadata">

**Author:** ![maha\_lazrak](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/maha_lazrak/32/3447_2.png) [@maha\_lazrak](https://community.piwik.pro/u/maha_lazrak)\
**Post date:** [June 3, 2024, 12:36pm UTC](https://community.piwik.pro/t/piwik-calculated-metrics/4063/5 "2024-06-03T12:36:57Z")

</div>

Hello,  
Okey ! thank you so much !!