Hello Everyone, I am stuck at building a trending dashboard. My data in table format:- _time,  ProjectName, summary1, summary2 2021-04-06 05:41:30.027 ProjectA 121 173 2021-04-07 07:06:00.983 ProjectA 121 173 2021-04-08 02:30:47.883 ProjectA 121 173 2021-04-09 05:09:43.243 ProjectA 130 173 2021-04-10 12:07:51.513 ProjectA 130 173   I want to build a dashboard visualization such as a comparison for summary data and yesterday data/last weeks data, last month , last quarter data based on a input field.   So that we can derive what was the summary last week for project A, last month for project A, and so on   I tried  the search  | timechart avg(summary1), avg(summary2) by ProjectName span=w@w1 | timewrap 1mon ... View more