Nikolas Koesling NikolasK-source

## vz.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                NikolasK-source
                / vz.md
            
            
              Last active
              June 1, 2020 19:22
                — forked from adlerweb/vz.md
            
              
                Grafana MySQL query to visualize Volkszähler-Data
              
          
        
      
        
  
      
    Using Channel-IDs (that's not UUID)

SELECT
  timestamp * 0.001 as time_sec, 
  data.value as value, 
  properties.value as metric
FROM data
  LEFT JOIN properties ON (properties.entity_id = data.channel_id)
  LEFT JOIN entities ON (entities.id = data.channel_id)