community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Adobe Analytics Connector Week Starting Monday

Highlighted

Hello!

 

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(),
	-(Switch(DateTimeFormat(DateTimeToday(),"%a"),0
	,'Sun',1
	,'Mon',2
	,'Tue',3
	,'Wed',4
	,'Thu',5
	,'Fri',6
	,'Sat',7))
	,'days')),-6,'days')

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.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

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