Comments
-
Big Time Need for Date Variables: Set the default to MYSQL functions like Current_Date. I would guess that 80% of users would prefer this to be the default for a date variable.
-
Big Time Need for Date Variables: Set the default to MYSQL functions like Current_Date. I would guess that 80% of users would prefer this to be the default for a date variable.
-
@kgr can you help me out - how did you make a custom query?
-
Thank you!
-
I am running into this problem as well. Tends to be when I copy a card existing elsewhere to a dashboard.
-
I actually found a solution. In beastmode (because the timestamps are correct in the transform) I used convert_tz(`date`,'us/eastern','us/eastern'). This corrected the timestamps and properly took into consideration daylight savings.
-
Unfortunately, I have tried convert_tz and our admin setting are set with our timezone correctly.
-
To make this a little easier to understand. My table ends up looking like what is listed below and I want to be able to count(action) / sum(Hours). The hours field needs to be restructured though so that it doesn't count the same hours multiple times. Date | Action | Hours | 6/21 | Act 1 | 8 | 6/21 | Act 2 | 8 | 6/21 | Act…
-
Thank you this did help, but I still need some more advice to get my end result. I know have the two tables joined together as you describe below. This leaves me with these key columns among others. Employee, Action, Timestamp of Action completed, Emply Daily Start Time, Employ Daily End Time, Hours (worked that day) The…
-
So I settled on this code in a transform but I am getting an error Create Function GetWorkingMin(@StartDate DateTime, @EndDate DateTime, @Country Varchar(2)) Returns Int Begin Declare @WorkMin int = 0 -- Initialize counter Declare @Reverse bit -- Flag to hold if direction is reverse Declare @StartHour int = 8 -- Start of…
-
Awesome thanks so much!
-
Thank you for the quick response! I found this code on StackOverflow which has a generic procedure I want to use. Here: Create Function GetWorkingMin(@StartDate DateTime, @EndDate DateTime, @Country Varchar(2)) Returns Int AS Begin Declare @WorkMin int = 0 -- Initialize counter Declare @Reverse bit -- Flag to hold if…
