Aggregated running product or product of list measure

What I'm facing is: Every hours we take a value from our systems and store it on a dimension called results. I need to calculate a running_product of this values aggregated on a timeframe defined by the user. (value_1 * value_2 * value_3.....value_n)
I thought about creating a dynamic dimension and a parameter where user can select what timeframe he wants and than create a list measure using the results dimension so it would aggregate every single result on for a week (month, year or w/e was selected) and than create a table calculation with the product() function but the product() won't work since the list measure store values as strings.
Anybody ever had to deal with something similar?

471543f1-896f-4f4a-8ba7-cb083a4ee715.png
This is how my data looks like
a25b5812-65b2-4333-b0cf-c3f4183fa8bf.png
This is how the list measure looks like. I would like to apply a product() on it
0 2 564
2 REPLIES 2
Top Labels in this Space