"""
# Hourly Variation of Data across days
"""
"""
### Objective
To see the hourly variation of power generated and temprature across dates per inverter
"""
"""
**How to use the dashboard:**
1. A line on each graph represents information from a date
2. X axis in all line graphs represents the hour of the day
3. Inverter ID is the source key from the plant table
4. Clicking on a line will highlight that data point in all the graphs
5. Filter icon displays a day level scatter plot between - Sum(AC Power) vs Avg(Ambient Tembrature)
6. You can use the scatter plot to filter the highlight the lines on the other graphs, it will help in understanding instances like high temprature

**Note:** Use the dashboard in desktop mode, full screen for better. You can go to <a href="https://tinyurl.com/y4uvshj7">this link</a> to view the dashboard better
"""
%%html
<div class='tableauPlaceholder' id='viz1601916844713' style='position: relative'><noscript><a href='#'><img alt=' ' src='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;So&#47;SolarPlantKaggle&#47;HourlyVariation&#47;1_rss.png' style='border: none' /></a></noscript><object class='tableauViz'  style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='3' /> <param name='site_root' value='' /><param name='name' value='SolarPlantKaggle&#47;HourlyVariation' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;So&#47;SolarPlantKaggle&#47;HourlyVariation&#47;1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /><param name='language' value='en' /><param name='filter' value='publish=yes' /></object></div>                <script type='text/javascript'>                    var divElement = document.getElementById('viz1601916844713');                    var vizElement = divElement.getElementsByTagName('object')[0];                    if ( divElement.offsetWidth > 800 ) { vizElement.style.width='100%';vizElement.style.height=(divElement.offsetWidth*0.75)+'px';} else if ( divElement.offsetWidth > 500 ) { vizElement.style.width='100%';vizElement.style.height=(divElement.offsetWidth*0.75)+'px';} else { vizElement.style.width='100%';vizElement.style.height='1327px';}                     var scriptElement = document.createElement('script');                    scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js';                    vizElement.parentNode.insertBefore(scriptElement, vizElement);                </script>
"""
**Aggregation present at hour level:**
* Max of Daily Yield per hour
* Sum of AC Power/ DC Power per hour
* Average of Ambient and Module Temprature
* Sum of irradiation
"""