Forum Discussion

JHarmon's avatar
JHarmon
Regular Visitor
2 years ago

Line chart only shows missing data gaps when adding multiple x-axis inputs

Becuase the IoT sensor data is coming in at slighly varying times, once in a while a time slot is skipped, creating gaps when combining sensor data in the chart.  No actual data points are missing, t...
Need Help
ChiragGarg2512's avatar
ChiragGarg2512
Solution Sage
2 years ago

JHarmon , go to x-axis setting of the visual in format setting and change the type to "Categorical".

  • JHarmon's avatar
    JHarmon
    Regular Visitor
    2 years ago

    I'm not seeing "Type" or "Categorical" option.  Am I looking in the right location?

     

    • JHarmon's avatar
      JHarmon
      Regular Visitor
      2 years ago

      Actually....after digging more, when I drill up and only have "Date" on the X-Axis, I can change to "Categorical", but when I drill back down and have Minutes, Dates, "Categorical" is no longer an option, nor applies.  Is there a solution in this case?

       

      • ChiragGarg2512's avatar
        ChiragGarg2512
        Solution Sage
        2 years ago

        Just tallied your data and their is no value of that sensor at that time. For ex. There is no value for sensor 10 at 8:40 PM or sensor 6 for 8:50 PM so it will not have values to map on the graph. It leaves 8:50 PM for sensor 6 from the axis because there is no value of sensor 6 at that time, this issue can be changed by categorical or continuous. Gap doesn't exist in just sensor 6 graph because all the values are mapped. For multiple line chart with a continuous 10 min time distribution there are some sensors with no output at a point and some output at that point, so the gaps will continue to exist.