Alteryx Designer Desktop Discussions

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

How do I create an Analytic App - Very basic

cyeager
8 - Asteroid

How Can I create an Analytic App?

 

I have a large Alteryx file.  I basically want a user to be able to type in the store number, and select the Department by a drop down, in which the results would be a file of about 100 rows of data per store-Dept.  Seems very simple... but I'm amazed at how I still am unsure of how to do this despite using Alteryx for years now.  I think it's a macro or Analytic App that is needed.

 

Thanks for your help  (attached sample file)

 

Column Names:

Store

Department

Category

Sales$

 

8 REPLIES 8
atcodedog05
22 - Nova
22 - Nova

Hi @cyeager 

 

Here is an example of how you can do it.

Workflow:

atcodedog05_0-1632497877823.png

 

Hope this helps : )

MatthewBr
Alteryx Alumni (Retired)

Take a look at the attached. If this works - Please mark this as complete. 

Matt

 

MatthewBr_0-1632498297498.png

 

cyeager
8 - Asteroid

I look looks great, however, I'm not sure what I need to click within the Drop down Nodes, and Action node... I'm not sure how to recreate a selection pop-up file like the one you attached.  I'm also not sure how to get the top left Node's top @ symbol to not be there.  Thank you for your help... I'm getting closer to understanding. 🙂

 

cyeager_0-1632499478494.png

cyeager_1-1632499509665.png

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @cyeager 

 

Refer to this interactive lesson

https://community.alteryx.com/t5/Interactive-Lessons/Creating-Drop-Downs/ta-p/243115

 

Hope this helps : )

 

cyeager
8 - Asteroid

Thanks, I learned I can easliy use "Manually set Values..." and paste in the desired drop down items.  I'm not sure how to get the @ symbol of the top left node, perhaps it's a different node that looks like the "Drop Down" node.  However, I'm still not able to get the App pop-up for it work as a quick grab select data tool.

atcodedog05
22 - Nova
22 - Nova

Hi @cyeager 

 

You are thinking about this method I guess.

 

Workflow:

atcodedog05_0-1632501595635.png

 

Hope this helps : )

cyeager
8 - Asteroid

I get the error on the Formula: The Field "" is not Contained in the record. (Expression #1).  The File that is shared to me is the app, I'm not sure of the details crosstab or Dynamic Rename, select store number or action node, that makes it work.  Once it works, I'm not sure what/where someone would click to get the App screen.

 

cyeager_0-1632503955739.png

Thank you for your help... very basic stuff probably, but it helps fill in the gaps of my understanding.

cyeager
8 - Asteroid

Unfortunately, I am still not understanding how to perform this basic analytical app.  Thank you in advance for helping show me what steps I'm missing from the above explanation. ty

Labels
Top Solution Authors