AB Trend error - inifinite or missing values in 'x'

Question

Hi,

I'm experiencing an issue with the AB Test function in Alteryx. The error message suggests that I'm fields that have missing values. But I've checked my data and haven't found any missing values:

Error: AB Trend (3): Tool #225: Error in svd(x, nu = 0) : infinite or missing values in 'x'
Error: AB Trend (3): Tool #225: Execution halted
Error: AB Trend (3): Tool #225: The R.exe exit code (1) indicated an error.

I've attached photos of my workflow and I've attached the input file (WeeklySToreTraffic) that i'm using.

Anyone who can help me to solve this?

Thanks

WeeklyStoreTraffic.yxdb

KaneG · Accepted Answer

Hi @ROUD89,

The issue here is that weekly is selected as the report period type and not all the data is aggregated to Weekly data.

To find this out, I did a summarize on:

* [Week_End]: Group By, Count

followed by a formula tool:

* DayOfWeek: DateTimeFormat([Week_End],'%A')

You will be able to see in this dataset that Thursday is the normal end of week but there is dates on other days as well.

To fix this, I crudely just created a new field with the following formula (Note: I'm sure there is a better way, but I just did it quickly with Copy/Paste):

IF DateTimeFormat([Week_End],'%A')='Wednesday'
THEN DateTimeAdd([Week_End],1,'days')
ELSEIF DateTimeFormat([Week_End],'%A')='Tuesday'
THEN DateTimeAdd([Week_End],2,'days')
ELSEIF DateTimeFormat([Week_End],'%A')='Monday'
THEN DateTimeAdd([Week_End],3,'days')
ELSEIF DateTimeFormat([Week_End],'%A')='Sunday'
THEN DateTimeAdd([Week_End],4,'days')
ELSEIF DateTimeFormat([Week_End],'%A')='Saturday'
THEN DateTimeAdd([Week_End],5,'days')
ELSEIF DateTimeFormat([Week_End],'%A')='Friday'
THEN DateTimeAdd([Week_End],6,'days')
ELSE [Week_End]
ENDIF

Once the data is aggregated correctly, the A/B tool works properly.

If you are interested, what was happening was that behind the scenes, columns were being created for the other dates, and naturally data didn't exist for all the stores as below, hence the error referring to Nulls:

I've attached the module that I used to check and correct the Week_End.

Kane