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?