How do I create an Analytic App - Very basic

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

Accepted answers

All comments

atcodedog05

Hi @cyeager

Here is an example of how you can do it.

Workflow:

Hope this helps : )

stores.yxwz

MatthewBr

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

Matt

SimpleAnalyticApp.yxwz

cyeager

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

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

Hi @cyeager

You are thinking about this method I guess.

Workflow:

Hope this helps : )

stores.yxwz

cyeager

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.

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

cyeager

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703