Scatter plot gives error "no valid fields were selected"

Dear All ,

I'm trying to build a Liner regression Model, when I try to display the results on a scatter plot I got the following problems:

1-I didn't get the list of (X, Y) fields to select them to be displayed.

2-I got an error said (no valid fields were selected).

Please check the following Image and WF to double check.

Error Scatter Plot.JPG

WF_P_2.yxmd

p1-customers.xlsx

Workflow

Error Message

Accepted answers

ChrisHe

Hey @MAAbdullahAlMubarah,

The Scatter Plot tool will only take numeric fields for the X axis, so you won't be able to get Customer_Segment there with that tool. However you can get the same effect by building your own custom visualization with the Interactive Chart in the Reporting tool palette. One thing to note is that you won't have access to this tool unless you have version 2018.3 of Designer installed.

I've attached an example with the chart you're looking for built out.

Best,

Chris

WF_P_4.yxmd

All comments

ChrisHe

Hey @MAAbdullahAlMubarah

The workflow you attached is different from the image in your post; it also uses two diamond data sets I don't have access to. In the image you posted, the main issue is that you've sent the model output (which is an R model object) to the scatterplot instead of scoring the data and sending those results to the scatterplot. In the workflow you sent it seems to be set up properly at first glance but there may be an issue with the metadata flowing through to the scatterplot tool. Is it possible to provide a packaged workflow so I can work through the error message?

If not, one thing you may want to try is confirming that your Linear Regression tool has a model name assigned in the configuration as it is currently blank. Happy to dig further if you can pass along some test data!

Best,

Chris

MAAbdullahAlMubarah

Hi Chris ,

For your Question

"Is it possible to provide a packaged workflow so I can work through the error message?" , I'm New In Alteryx and I don't know what do you mean by (Package Workflow) My Alteryx Version is (2018.3.4.51585).
You said in the meta-data there is a (Diamond) data as a source but I checked the setting of the Liner tool it doesn't contain any metadata related to (Diamond) It is for (p1-Customer) Data source as is shown in the Image below.
In Addition, I try to output the report for the Liner regression to get the results but It didn't give me anything, I did the practics as it is stated in Alteryx Videos and documents. I'll be appreciated if you create a new workflow from scratch using my csv file with the similar scenario between 2 fields:

1-Customer Segmentation with 4 categories detailed in the formula tool.

2-The Predicted value is Avg Amount (Numeric).

I attached all the needed files and waiting for your updates.

Work Flow.JPG Liner Tool.JPG

WF_P_3.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703