Best Of
Re: Unable to Access Magic ETL Output
Thanks, the details link sent me to the same dead end. I have submitted a support ticket.
Re: Unable to Access Magic ETL Output
That is odd. I would try editing the ETL, clicking on the output dataset and then click on Details and then click on the hyperlink that is the dataset name. If it takes you to to the same dead end, I would log a support ticket.
Re: Calculating Time Difference
You could use
DATEDIFF(minute, Created Time, Response Time)
This will return the number of minutes between Creation and Response.
If you want to exclude non-working hours you might need to use a master calendar with a field like date start time and date end time with work start and end time for every day and use the sum of multiple datediff()'s to get to your result.
Re: NUMBER_FORMAT function
This would be a GAME CHANGER!! Its so tedious to have to add this formatting in one-by-one. If there is a way to change formatting in columns and instead use a beast mode, that would speed up the process on 20+ column cards. Could also expand the reach to better include financial statements.
Re: NUMBER_FORMAT function
This indeed would be very helpful. I would use this often. Please make it happen!
Re: NUMBER_FORMAT function
I can already think of several past dashboards I've built that would greatly benefit from this - would love for this to be brought to life!!
