{"type":"doc","content":[{"type":"expand","attrs":{"title":"Watch video tutorial"},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"widget","parameters":{"macroParams":{"overlay":{"value":"youtube"},"_template":{"value":"com/atlassian/confluence/extra/widgetconnector/templates/youtube.vm"},"width":{"value":"600px"},"url":{"value":"http://youtube.com/watch?v=6ZubYxph_fw"},"height":{"value":"300px"}},"macroMetadata":{"macroId":{"value":"e531f287be673a2225794046aa1ed013"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"image","data":{"url":"/plugins/servlet/widgetconnector/placeholder?thumb=https://img.youtube.com/vi/6ZubYxph_fw/mqdefault.jpg&overlay=youtube&width=600&height=300"}}],"title":"Widget Connector"}},"localId":"45a709dd-eef6-40cb-8dec-2698a54bf9e2"}}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"minLevel":{"value":"1"},"maxLevel":{"value":"2"},"type":{"value":"flat"}},"macroMetadata":{"macroId":{"value":"5899e833ae8e49a51961427ca31b5b04"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"c6d40081-6f9c-4949-b446-eaaa3407be4f"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Overview","type":"text"}]},{"type":"paragraph","content":[{"text":"Devo allows you to manually enter a time range in the indicator for both your entire Activeboard or individual widgets and inputs, giving you more flexibility and precision when searching your data. Simply click on the time range indicator in the top right and enter the desired dates or edit existing ones. The background of the time range indicator changes to red until a valid date is entered.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Coherent time ranges","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Your ","type":"text"},{"text":"from","type":"text","marks":[{"type":"strong"}]},{"text":" date cannot be after your ","type":"text"},{"text":"to","type":"text","marks":[{"type":"strong"}]},{"text":" date and your ","type":"text"},{"text":"to","type":"text","marks":[{"type":"strong"}]},{"text":" date cannot be in the future. ","type":"text"}]}]},{"type":"paragraph","content":[{"text":"You can use a mix of both absolute and date language expressions in any given time range (for example, the ","type":"text"},{"text":"to","type":"text","marks":[{"type":"strong"}]},{"text":" date can be relative and the ","type":"text"},{"text":"from","type":"text","marks":[{"type":"strong"}]},{"text":" date absolute, and vice versa). For date language expressions, the current moment \"now()\" is used as the reference point.","type":"text"}]},{"type":"paragraph","content":[{"text":"Now look how this is reflected in a widget:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1167,"id":"72674253-1448-41ea-bfe7-09a8d7ee1a2c","collection":"contentId-314181378","type":"file","height":353}}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Real-time deactivated after editing","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"The real-time option is deactivated if you manually edit an existing time-range that has it activated, so you will need to reactivate it. Furthermore, the real-time option is only available for time ranges that use at least one date language expressions in the to or from field.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Operators","type":"text"}]},{"type":"paragraph","content":[{"text":"You can establish absolute dates in the required format:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"b8ffabb0-0362-4142-b923-e54bbd6d0c16"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[160.0]},"content":[{"type":"paragraph","content":[{"text":"Operator","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[429.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[160.0]},"content":[{"type":"paragraph","content":[{"text":"yyyy-MM-dd hh:mm:ss","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[429.0]},"content":[{"type":"paragraph","content":[{"text":"Establishes the specified absolute date","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"2021-06-30 15:35:23","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"With date language expressions, use a series of mathematical operations to move away from the current time which is used as the reference point. You can use multiple operators at once and the execution order is from left to right:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"7b504bc1-c8d7-4ddf-bc98-53d0403dedcf"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[164.0]},"content":[{"type":"paragraph","content":[{"text":"Operator","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[425.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[164.0]},"content":[{"type":"paragraph","content":[{"text":"Snap to (@) or |<","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[425.0]},"content":[{"type":"paragraph","content":[{"text":"Rounds the date to the beginning of a time unit. Note that this operator only works with 1m, 1d, 1h, 1w, 1W, 1M and 1y.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"now() @ 1m or now() |< 1m","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[164.0]},"content":[{"type":"paragraph","content":[{"text":"Arithmetics (+/-)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[425.0]},"content":[{"type":"paragraph","content":[{"text":"Applies an offset to the date (date + offset or date - offset)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"now() - 3h","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[164.0]},"content":[{"type":"paragraph","content":[{"text":"Replace (^)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[425.0]},"content":[{"type":"paragraph","content":[{"text":"Replaces part of the date by a time unit (date ^ time_unit)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"now() ^ 6d","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[164.0]},"content":[{"type":"paragraph","content":[{"text":"Backward & forward (>>/<<)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[425.0]},"content":[{"type":"paragraph","content":[{"text":"Shifts the date to the next/past time unit (date >> time_unit or date << time_unit)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[170.0]},"content":[{"type":"paragraph","content":[{"text":"now() << 11M","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Time expressions","type":"text"}]},{"type":"paragraph","content":[{"text":"Let's suppose the current time (which we refer to as \"now()\") is ","type":"text"},{"text":"Sunday, 05 February 2017, 13:37:05. ","type":"text","marks":[{"type":"strong"}]},{"text":"The table below shows the resulting time when different expressions are applied. All dates and times are GMT+1. Note that this isn't an exhaustive list:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"0a3ce9c7-89fa-4d6d-ad59-12e906471174"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Time expression","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Resulting time","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() - 60m","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"60 minutes ago","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Sunday, 05 February 2017, ","type":"text"},{"text":"12","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":":37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() @ 1h","type":"text"},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Now (rounded to the beginning of the hour)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Sunday, 05 February 2017, 13:","type":"text"},{"text":"00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() - 24h","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"24 hours ago","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Saturday, ","type":"text"},{"text":"04","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, 13:37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"(now() - 1d) @ 1d","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Yesterday (rounded to the beginning of the ","type":"text"},{"text":"day","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":")","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Saturday, ","type":"text"},{"text":"04","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, ","type":"text"},{"text":"00:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"(now() - 2d) @ 1d","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"2 days ago (rounded to the beginning of the ","type":"text"},{"text":"day","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":")","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Friday, ","type":"text"},{"text":"03","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, ","type":"text"},{"text":"00:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"(now() - 2d) @ 1m","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"2 days ago (rounded to the beginning of the ","type":"text"},{"text":"minute","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":")","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Friday, ","type":"text"},{"text":"03","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, 13:37:","type":"text"},{"text":"00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"((now() - 2d) @ 1d) - 2h","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"2 days ago (rounded to the beginning of the ","type":"text"},{"text":"day minus 2 hours","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":")","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Thursday, ","type":"text"},{"text":"02","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, ","type":"text"},{"text":"22:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() @ 1w","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Locale week","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Sunday","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 05 February 2017, ","type":"text"},{"text":"00:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() @ 1W","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"ISO week","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Monday","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", ","type":"text"},{"text":"30 January","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" 2017, ","type":"text"},{"text":"00:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() ^ 6d","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Replace the day with 6","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Monday, 06","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, 13:37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() ^ 2018y3M6d15h30m20s","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Replaces the year with 2018","type":"text"},{"type":"hardBreak"},{"text":"Replaces the month with 3","type":"text"},{"type":"hardBreak"},{"text":"Replaces the day with 6","type":"text"},{"type":"hardBreak"},{"text":"Replaces the hour with 15","type":"text"},{"type":"hardBreak"},{"text":"Replaces the minutes with 30","type":"text"},{"type":"hardBreak"},{"text":"Replaces the seconds with 20","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Tuesday, 06 March 2018, 15:30:20","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() >> 2M","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Forward to ","type":"text"},{"text":"next","type":"text","marks":[{"type":"strong"}]},{"text":" second month","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Monday","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 05 February ","type":"text"},{"text":"2018","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 13:37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() << 2M","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Backward to ","type":"text"},{"text":"previous","type":"text","marks":[{"type":"strong"}]},{"text":" second month","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Friday","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 05 February ","type":"text"},{"text":"2016","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 13:37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() >> 2M6d15h20m10s","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Forward to ","type":"text"},{"text":"next","type":"text","marks":[{"type":"strong"}]},{"text":" second month, sixth day, fifteenth hour, twentieth minute and 10 seconds","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Tuesday, 06 February 2018, 15:20:10","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"now() << 1h/1d","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Goes back to the first hour of the current day. Minutes and seconds don't change.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.67]},"content":[{"type":"paragraph","content":[{"text":"Sunday, 05 February 2017, 01:37:05","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Examples","type":"text"}]},{"type":"paragraph","content":[{"text":"Let's take a look at the mathematical operators in action. Imagine that the current moment, which we always refer to as \"now()\" is Wednesday, 27 January 2021.","type":"text"}]},{"type":"expand","attrs":{"title":"Example 1"},"content":[{"type":"paragraph","content":[{"text":"In this example, we want to show data from 70 days ago, rounded to the beginning of the day. To achieve this we enter ","type":"text"},{"text":"\"now() - 70d @1d\"","type":"text","marks":[{"type":"strong"}]},{"text":" in the from field and ","type":"text"},{"text":"\"now()\"","type":"text","marks":[{"type":"strong"}]},{"text":" in the to field.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":66.0},"content":[{"type":"media","attrs":{"width":828,"id":"3621e021-45c3-46e1-a624-aec0cedd7d54","collection":"contentId-314181378","type":"file","height":400}}]}]},{"type":"expand","attrs":{"title":"Example 2"},"content":[{"type":"paragraph","content":[{"text":"In this example, we want to shift the current month back to June of the previous year and the current day with the first of the month. We want to shift our to date back to August. To achieve this we enter ","type":"text"},{"text":"\"now() <<6M1d\"","type":"text","marks":[{"type":"strong"}]},{"text":" in the from field and ","type":"text"},{"text":"\"now() <<8M\"","type":"text","marks":[{"type":"strong"}]},{"text":" in the to field.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":66.0},"content":[{"type":"media","attrs":{"width":830,"id":"db5ba943-ef79-48c9-8d33-d628e353d121","collection":"contentId-314181378","type":"file","height":399}}]}]},{"type":"expand","attrs":{"title":"Example 3"},"content":[{"type":"paragraph","content":[{"text":"Here we want to hone in further on the previous example. We want to shift our current moment to 22 June and subtract 5 hours. We want to shift our to date back to August and subtract 13 days. To achieve this we enter ","type":"text"},{"text":"\"(now() <<6M22d)-5h\"","type":"text","marks":[{"type":"strong"}]},{"text":" in the from field and ","type":"text"},{"text":"\"(now() <<8M)-13d\"","type":"text","marks":[{"type":"strong"}]},{"text":" in the to field.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":66.0},"content":[{"type":"media","attrs":{"width":832,"id":"f46e749e-ddba-44f4-8245-0dbd8ea9366d","collection":"contentId-314181378","type":"file","height":397}}]}]},{"type":"paragraph"}],"version":1}

Browser not supported