- Last Active
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!