Comments
-
Try: TRIM(SUBSTR(t5.ADDR_ZIP,0,5)) Where 0 is the start and 5 is the stop for extracting your string.
-
Gotcha - I've had the same issue in the past. I don't know if there's a way to split the legend, but you can change the settings to move the legend to the top, bottom, etc. and reverse the layout order in Chart Properties-General
-
Switch your series and Y axis values.
-
I tried this and it looks like it works. (DATEDIFF(CURDATE(),'12/31/2016') / DATEDIFF('12/31/2016','10/1/2016'))*-1 It's not complete, but you can definitely use a CASE WHEN argument to move this value dynamically. Try it without the CASE WHEN first, then you can add clauses later. Not 100% sure how to avoid hard coding…
-
Just curious, are you running a Beastmode, or using Workbench (either a transform or query)? Try updating the last formatting clause in your Concat string as '%m/%d/%Y' vs '%m%d%Y' (notice the backslashes). Hope this helps!
-
AS, Thanks very much for the info, this is exactly what I was looking for! KH
