Jump to content

Recommended Posts

Posted

I am using the advanced analytics and producing some widgets, however the variables to use are different than in the reporting.

 

My widget shows last week but I am using h_datelogged > (now() - interval 1 WEEK) which gives me a rolling week and want it to display the last week but with the week end day as Sunday. In supportworks this would be DATE:endoflastweeksun

Can someone help with what the available time periods are? This does not help - https://wiki.hornbill.com/index.php?title=SQL_Reference:_Date_Time_Functions

Posted
17 minutes ago, katy_palmer said:

this will do the same as DATE:endoflastweeksun - correct?

I have no idea what this "DATE:endoflastweeksun" does. My above filter will return all requests that have been raised in the previous Mon - Sun week from the date the report is run. So if it was run a query today, using the filter, it will bring back requests raised between 01/07/2024 and 07/07/2024.

  • Like 1
Posted
1 hour ago, katy_palmer said:

the fact that the time periods are not the same throughout the system

We wouldn't raise an enhancement in Hornbill because it differs from Supportworks. They are completely separate products.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...