New Member
Since ‎04-09-2019
‎05-20-2023

My Stats

  • 41 Posts
  • 0 Solutions
  • 2 Likes given
  • 7 Likes received

adstott90's Bio

Badges adstott90 Earned

View all badges

Recent Activity

Hi all,We have currently made a pretty significant update to our underlying data structure that meant a number of dashboards were replaced with newer versions. As a result, a lot of dashboards were archived and new dashboards with the same name were ...
Hi all,Hoping someone can help me - I have a simple SQL query that pulls a count of customers for the current date, although I want to trend that back for, let’s say arbitrarily, 2 years. How would I go about this?SELECT CAST(CURRENT_DATE() AS TIMEST...
Hi all, I’m working on a query at the moment and I want to compare the weekly revenue and customers with that of the previous year. Sounds straightforward, except that I want to compare weeks of the financial year (starts 01/04/2020) with last year. ...