Info
Content

Plex Data Panels (Movie Count, Bandwidth, Recently Added, etc.)

all_plex_data_panels.jpg

With the necessity for Plex, Tautulli, Varken, Grafana and InfluxDB this is without a doubt the most complex series of panels on my dashboard. It's a lot of stuff, but it's amazing when everything clicks and it's all working properly.

There is a Varken dashboard you can download from Grafana (download here) that has *all* of the possible panel configurations, including panels that I don't use here like Ombi, Sonarr, Radarr and the World Map. It would not be unwise to go download that dashboard from Grafana as it helped me a great deal when configuring this custom dashboard.

It's worth noting that before implementing the queries I've laid out here, all of the below dependencies must be working correctly first. I will post the tutorials for all of these dependencies when they become available.

This tutorial is cross platform compatible.

Dependencies:

1. Stream Count

Streams.jpg

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

Streams_Query.jpg

The query itself:

 SELECT "stream_count" FROM "Tautulli" WHERE ("type" = 'current_stream_stats') AND $timeFilter

2. Transcodes Count

transcodes.jpg

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

transcodes_query.jpg

The query itself:

SELECT "transcode_streams" FROM "Tautulli" WHERE ("type" = 'current_stream_stats') AND $timeFilter

3. Movies Count

movies.jpg

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

movies_query-800x254.jpg

The query itself:

SELECT last("total") FROM "Tautulli" WHERE ("type" = 'library_stats' AND "section_name" = '1 Movies') AND $timeFilter

4. Recently Added Movies

recently_added_movies.jpg

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

recently_added_movies_query-800x262.jpg

The query itself:

SELECT distinct("total") FROM "Tautulli" WHERE ("type" = 'library_stats' AND "section_name" = '1 Movies') AND $timeFilter

5. TV Shows Count

tv_count.jpg

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

tv_shows_count.JPG

The query itself:

SELECT distinct("total") FROM "Tautulli" WHERE ("type" = 'library_stats' AND "section_name" = '1 Movies') AND $timeFilter

6. Bandwidth Usage

bandwidth.jpg

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

bandwidth_usage.JPG

The query itself:

SELECT "total_bandwidth" FROM "Tautulli" WHERE ("type" = 'current_stream_stats') AND $timeFilter

7. TV Seasons

tv_seasons.JPG

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

tv_seasons_query.JPG

The query itself:

SELECT last("seasons") FROM "Tautulli" WHERE ("type" = 'library_stats' AND "section_name" = '2. TV Shows') AND $timeFilter

8. WAN Bandwidth

WAN_bandwidth.JPG

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

WAN_bandwidth_query.JPG

The query itself:

SELECT "wan_bandwidth" FROM "Tautulli" WHERE ("type" = 'current_stream_stats') AND $timeFilter

9. Device Type

davice_type.JPG

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

davice_type_query.JPG

The query itself:

SELECT count(distinct("hash")) FROM "Tautulli" WHERE ("type" = 'Session') AND $timeFilter GROUP BY "device_type"

10. Now Playing

now_playing.JPG

Data source:

varken_data_source.jpg

Actual Grafana query builder setup:

now_playing_query.JPG

The query itself:

SELECT mean("value") FROM "measurement" WHERE $timeFilter GROUP BY time($__interval) fill(null)
Back to top