Grafana needs to specify the retention policy in the query to query a non-DEFAULT RP: https://docs.influxdata.com/influxdb/v1.0/troubleshooting/frequently-asked-questions/#why-am-i-missing-data-after-creating-a-new-default-retention-policy
On Fri, Nov 11, 2016 at 5:01 AM, <[email protected]> wrote: > Hello, > > I Hop some one here can help me explain how to use domnsampled data. > In a test we run collectd with two retention policies and continuous > queries to downsample the data. > > The thing I dont understand, is I can query the downsampled data just > fine, but how to I get grafana to display the aggregated old data? > All we see is the hour data. > > Retentions: > > two_hours "2h0m0s" "1h0m0s" 1 true > a_year "8736h0m0s" "168h0m0s" 1 false > > > CQ: > cq_30m "CREATE CONTINUOUS QUERY cq_30m ON collectd BEGIN SELECT mean(*) > INTO collectd.a_year.downsampled_cpu_value FROM > collectd.two_hours.cpu_value WHERE time > now() - 1h GROUP BY time(10m), * > END" > > > I do get output when running the (adjusted) CQ from the CLI, and I do see > the other policies in grafana, but not any old data. > > Can any one please point me in the right direction? > > Thanks in advance > > Leen > > -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/a670b86e-b677-4467-89be-5c26d6129b32%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvPv%2Bm0v-pgU04jPtdnCgVg_ribZrGdYCujFPR0tRETiRg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
