Thanks Joel! This worked. However is there any way to make the time period dynamic. Ie. Instead of Month a user within DGLux would be able to select past 'Month, 2months, 3months or year.
I want to try to avoid creating seperate script and seperate variables for each time period.
I also was thinking if this is possible using a historical query table in DGLux? If I set the interval to 0 (when the parameter changes)
and set the period range (dynamic) and I sum the value column I believe I will end up with the count that I want.
Am I able to determine the sum of a column using a formula column and script? I have looked into using the rollup widget but have not been able to get anywhere with it.