2 Replies Latest reply on Dec 9, 2016 6:07 AM by John Wilson

    Anyone have experience with Clustering time series smart meter interval data in Tableau 10?

    John Wilson

      I have tried unsuccessfully to cluster time series interval data in tableau. My data set consists of about 1000 smart meters, with 30 min kwh interval readings. there are 48 reads per 24 hour period each marked with a time and date.

      When I enter the data and turn on clustering, it fragments each of my series of kwh into groups of individual kwh values that are close instead of clustering the entire 24 hour series with other series that are similar. Please see the example below.

      Below this example is the desired result. However, When I add more than 6 or 7 meters to the list it begins to fragment like the to picture.

      Any help would be appreciated.

      Thanks!

      Capture.PNG

      desired result.PNG