Classic Dashboard query - 3 visuals with 3 different times

[PaulaCom]

Hi all 

I have a dashboard that i need to build to show number of Helpdesk calls for :

1) year to date

2) Average monthly

3) Average daily 

i have the query set up and  I've selected 'year to date' 

I've done a | stats count and saved to Dashboard 

When i save this onto the dashboard the time has defaulted to last 24 hours. I've gone into the source editor and removed queryparameters but this hasn't helped

i think i need to set the time on my query (at the top) - year to date

Can some help me with this code ? 

Many thanks

P

[venky1544 · Accepted solution]

Hi @PaulaCom 

when you edit the dashboard and in the panel if you click the magnifying lens you should get below option where you can set the time range 

is it Something you have done it or did i understood your question wrong

[PaulaCom]

thank you 

i think i was making it more complicated than it needed to be 

worked perfectly 

P 🙂 

[PaulaCom]

so I've change the earliest to 

"earliest": "-6month@month",

                    "latest": "now"

i think this is it right?