• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 4 Documentation Website Mango 5 Documentation Website Radix IoT LinkedIn

    Data rollup option in Report(via Legacy UI)

    Scheduled Pinned Locked Moved User help
    4 Posts 2 Posters 1.5k Views 2 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • cwangvC Offline
      cwangv
      last edited by

      Hi,
      I am trying to create a report in the Legacy UI on points (kWh) that required 'Delta' rollup options.
      I notice there is an option called 'Map Key'. Is this the option for rollup?
      How else would I be able to generate such report?

      Thanks!

      1 Reply Last reply Reply Quote 0
      • phildunlapP Offline
        phildunlap
        last edited by

        Hi cwangv,

        The "Map Key" is simply the variable name to be used in the FTL under the "mapped" object. In the FTL it would look something like, <#if mapped.mapKey??></#if> which would check if a point with the map key "mapKey" was in the context. Otherwise as in the reportChartl.ftl file one would have to loop over the points list, so it is not easy to get the point you want there.

        To get the delta you could do something like, ${ mapped.mapKey.stats.delta } in the FTL.

        cwangvC 1 Reply Last reply Reply Quote 0
        • cwangvC Offline
          cwangv @phildunlap
          last edited by cwangv

          @phildunlap
          Hi, Phil
          Do you have more info on the syntax in the FTL that are available to use?

          Thanks.

          1 Reply Last reply Reply Quote 0
          • phildunlapP Offline
            phildunlap
            last edited by

            FTL itself has a lot of quality reference material on its website: https://freemarker.apache.org/

            If you mean what is included by Mango in the model passed to the template, the most authoritative place is the code: https://github.com/infiniteautomation/ma-modules-public/blob/main/Reports/src/com/serotonin/m2m2/reports/web/ReportChartCreator.java#L148

            So we'd have to look somewhere else to see what's available in a context other than the reports, like here's the email handler building its model: https://github.com/infiniteautomation/ma-core-public/blob/main/Core/src/com/serotonin/m2m2/rt/event/handlers/EmailHandlerRT.java#L269

            1 Reply Last reply Reply Quote 1

            Hello! It looks like you're interested in this conversation, but you don't have an account yet.

            Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

            With your input, this post could be even better 💗

            Register Login
            • First post
              Last post