# Continuous queries and grafana visualization

**URL:** <https://community.influxdata.com/t/continuous-queries-and-grafana-visualization/15129>\
**Category:** Systems\
**Created:** [July 7, 2020, 6:46am UTC](https://community.influxdata.com/t/continuous-queries-and-grafana-visualization/15129 "2020-07-07T06:46:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vladpov](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@vladpov](https://community.influxdata.com/u/vladpov)\
**Post date:** [July 7, 2020, 6:46am UTC](https://community.influxdata.com/t/continuous-queries-and-grafana-visualization/15129/1 "2020-07-07T06:46:58Z")

</div>

Hey everyone!

We try to create retention policies on our data so we can reduce amount of data we store. The point is to have a graph divided into tree parts where every part would have different CQ and RP as well I think.

So graph in Grafana would show 3rd part where is older data in 5mins intervals, 2nd part in 3mins intervals and last 1st part would be shown in real time.

I have three retention policies for each part one and three CQs for each of them, however, it doesn’t do the job ☹

```
autogen 168h0m0s 168h0m0s 1 true
rp.1part 1h0m0s 1h0m0s 1 false
rp.2part 2h0m0s 1h0m0s 1 false
rp.3part 3h0m0s 1h0m0s 1 false

> create continuous query "cq_part1" ON grafanatest1 BEGIN SELECT mean(*) INTO "rp.1part"."downsampled_1part" FROM "cpu_load_short" GROUP BY time(2m) END
> create continuous query "cq_part2" ON grafanatest1 BEGIN SELECT mean(*) INTO "rp.2part"."downsampled_2part" FROM "cpu_load_short" GROUP BY time(4m) END
> create continuous query "cq_part3" ON grafanatest1 BEGIN SELECT mean(*) INTO "rp.3part"."downsampled_3part" FROM "cpu_load_short" GROUP BY time(6m) END

```

Any advise would be appreciated!!

Thanks in advance for any help!

---

<div class="post-metadata">

**Author:** ![FixTestRepeat](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/fixtestrepeat/32/5208_2.png) [@FixTestRepeat](https://community.influxdata.com/u/FixTestRepeat)\
**Post date:** [July 8, 2020, 12:05pm UTC](https://community.influxdata.com/t/continuous-queries-and-grafana-visualization/15129/2 "2020-07-08T12:05:11Z")

</div>

> [@vladpov](#):
>
> however, it doesn’t do the job

What is “it” in this context? Which part of this workflow is not working?

Do your queries return any data if you run them manually?

SELECT mean(\*) INTO “rp.1part”.“downsampled\_1part” FROM “cpu\_load\_short” GROUP BY time(2m)

---

<div class="post-metadata">

**Author:** ![vladpov](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@vladpov](https://community.influxdata.com/u/vladpov)\
**Post date:** [July 8, 2020, 12:12pm UTC](https://community.influxdata.com/t/continuous-queries-and-grafana-visualization/15129/3 "2020-07-08T12:12:20Z")

</div>

Thanks for your reply!

I think the problem I’m trying to solve is better explained [here](https://community.influxdata.com/t/retention-policies-and-continuous-queries/15140).

I want to see in Grafana aggregated older data and raw data in the same graph…

---

<div class="post-metadata">

**Author:** ![Markmand](https://avatars.discourse-cdn.com/v4/letter/m/b9bd4f/32.png) [@Markmand](https://community.influxdata.com/u/Markmand)\
**Post date:** [July 8, 2020, 1:34pm UTC](https://community.influxdata.com/t/continuous-queries-and-grafana-visualization/15129/4 "2020-07-08T13:34:39Z")

</div>

i’m far from an expert. but your problem does seem strange. will check it more detailed later. if you find the solution update.