Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Adobe Analytics Connector Week Starting Monday




Does someone know how to change the specifics to the Adobe Analytics connector so that when I choose "Last Week" it shows me the last week of data starting Monday, not Sunday as it does now?


Thank you!

Alteryx Certified Partner
Alteryx Certified Partner

I'd submit it as an idea.  The connector is itself a macro (set of macros).  The offending logic is:


IF [preDefDropDown]="today" THEN DateTimeToday() 
ELSEIF [preDefDropDown]="yesterday" THEN DateTimeAdd(DateTimeToday(),-1,'days') 
ELSEIF [preDefDropDown]="last7Days" THEN DateTimeAdd(DateTimeToday(),-7,'days') 
ELSEIF [preDefDropDown]="last14Days" THEN DateTimeAdd(DateTimeToday(),-14,'days') 
ELSEIF [preDefDropDown]="lastWeek" THEN DateTimeAdd((DateTimeAdd(DateTimeToday(),

When you select last week you see SUNDAY gets hard-coded as 1 rather than 7.  If you change the macro, you need to rebuild the HTML and that won't be pretty.





Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.