topic Re: compare two weeks data by using timechart in Dashboards & Visualizations

compare two weeks data by using timechart

Allampally — Wed, 11 Jul 2018 07:45:25 GMT

Hi Experts,

I want to compare two weeks data by keeping week1 count in row1 and week2 count in row2.
Eg. index=* vip="abc.com:9001" | timechart span=1w count by user
My desired output should be

**_time             user1            user2             user3**   
**07/11/2018           10               20                30
  07/18/2018           50               60                70**

Re: compare two weeks data by using timechart

janispelss — Wed, 11 Jul 2018 08:00:24 GMT

If you select the right time range, your query should work. Is it not giving you the correct output?

Re: compare two weeks data by using timechart

Allampally — Wed, 11 Jul 2018 09:46:08 GMT

I can select time range only either first week or second week but not combinely both. I want the results for 1st week and 2nd week in two different rows

Re: compare two weeks data by using timechart

martin_mueller — Wed, 11 Jul 2018 10:40:30 GMT

Open the time range picker, go to advanced, use -2w@d and @d to search the past two weeks, snapped to midnight. Adjust if you want whole weeks, e.g. snapped to start of Monday: -2w@w1 and @w1.

Re: compare two weeks data by using timechart

woodcock — Wed, 11 Jul 2018 15:48:19 GMT

Like this:

index=* vip="abc.com:9001" earliest=-2w@d latest=@d | timechart span=1w count BY user