Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

L

Topics created by laona

L

Mango Scripting Data Source and Data Points

Scripting general Discussion
• • • laona

7

0
Votes

7
Posts

3.9k
Views

L

@JoelHaggar

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.

Thanks,