Next Hop graph is cut off

[yu-re-ka]

The query for the Next Hop panel in the overview dashboard has a LIMIT 100, but each output row is a data point and not a time series, so it cuts off the panel after the 100 earliest resulting data points.

[yu-re-ka]

Patch by @n0emis

diff --git a/deploy/dashboards/NetMeta_Overview.cue b/deploy/dashboards/NetMeta_Overview.cue
index 42cff43..bbd0662 100644
--- a/deploy/dashboards/NetMeta_Overview.cue
+++ b/deploy/dashboards/NetMeta_Overview.cue
@@ -65,17 +65,20 @@ _trafficStatisticQueries: {
            """#
    "Top 100 Next Hop":
        #"""
-           SELECT
+           SELECT time, NextHop, BitsPerSecond
+           FROM
+           (SELECT
                $__timeInterval(TimeReceived) as time,
                NextHop,
-               (sum(Bytes * SamplingRate) * 8 / $__interval_s) AS BitsPerSecond
+               (sum(Bytes * SamplingRate) * 8 / $__interval_s) AS BitsPerSecond,
+               row_number() over (partition by time order by BitsPerSecond DESC) as row_num
            FROM flows_raw
            WHERE $__timeFilter(TimeReceived)
            \#(_filtersWithHost)
            AND NextHop != toIPv6('::')
            GROUP BY time, NextHop
-           ORDER BY time
-           LIMIT 100
+           ORDER BY time) as subquery
+           where row_num <= 100
            """#
    "Traffic per Ingress Interface":
        #"""

[fionera]

@n0emis is it fine for you if I make a commit with that patch with you as author?

[n0emis]

Yes, sure. Go ahead