• 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 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    Excel report for multiple data points using same named range

    Scheduled Pinned Locked Moved User help
    2 Posts 2 Posters 737 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.
    • I Offline
      iperry
      last edited by

      Heya,

      I am trying to create an Excel report that details values for each sensor in the network every 10mins.

      0_1543275850373_12d3e667-0142-4ce3-a506-aaf71edd5f46-image.png

      0_1543276240929_2a135c75-c0d9-475b-8529-98c59036c4fc-image.png

      I can create the report setup and time period in the app for one sensor, i.e. L1-CS01-01 but when I try to assign the same named range to another data point, I get an error that the named range is already assigned.

      If I try to create another time period in the report for the 2nd sensor, I get the same error when associating the data point to the named range.

      Is it possible to create the report for multiple data points as I would like? Do I have to create a separate report for each sensor (set of data points)? I would like to avoid the separate reports as there may be 80+ sensors to report. Having a single report with multiple time periods would be tough to maintain.

      Thanks
      Ian

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

        Hi Ian,

        Why are you trying to do such a thing?

        No, a named range can only be associated with one time period or series in one time range. The reason being is that the ranges expand and you would never want one series to overwrite another (which I believe you could still achieve by having two named ranges grow over one another, one down and one over).

        If they are distinct time periods, why not put them on their own sheets? I would think Excel has the capacity to generate a column by appending columns on other sheets together.

        I would expect you want 80+ named ranges for the columns in the report. You could have all the points in the same time period in the excel report setup, but you would probably want to separate each sheet into its own time period so that each sheet has timestamps that you could append together to create something like the example excel cells you posted.

        1 Reply Last reply Reply Quote 0
        • First post
          Last post