• 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

    Report setup-"Location for time" and "Named range"

    Mango Automation general Discussion
    3
    4
    2.1k
    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.
    • J
      jackchang
      last edited by

      Hello,

      I try to setup excel report.
      My excel template:
      0_1478645464934_report1.PNG

      I don't know how to set up these:
      0_1478645505793_REPORT2.png

      Many thanks!
      Jack Chang

      1 Reply Last reply Reply Quote 0
      • J
        jackchang
        last edited by

        0_1478645596037_report1.PNG

        1 Reply Last reply Reply Quote 0
        • JoelHaggarJ
          JoelHaggar
          last edited by

          You need to create a named range in your excel file for the time stamps to go into.

          You also need to create named ranges for any data points. The ranges need to be at least 2 rows in a column. Once you upload the excel file with the named ranges they will show up in those drop down lists for you to select. Let me know if that helps.

          1 Reply Last reply Reply Quote 0
          • V
            v8dave
            last edited by

            The best way I found to do this was to create a second sheet and have Mango paste the data into that and then on the first sheet you simply link to the data on the second sheet.

            See sample below. Highlight at least 2-3 rows and then in the formulas tab choose create from selection. These are now what you select in Mango. Format the columns before you upload the Excel file.

            0_1478649010748_ExcelSample.png

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