Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

ROUD89
6 - Meteoroid

 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?

 

Thanksphoto3.PNGphoto2.PNGphoto1.PNG

2 REPLIES 2
KaneG
Alteryx Alumni (Retired)

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:

 

AB_missing_data.png

 

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

 

Kane

MAAbdullahAlMubarah
8 - Asteroid

Hi @KaneG

 

I have a similar case can you look at this thread:

 

 https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Errors-with-AB-Trends-tool-data-is-not...

 

I tried your solution but not work on my case, please Advise.

 

Labels