We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #5: HR Position Finder Application

SilviaRox
7 - Meteor

Hi there,

this was my first weekly challenge about analytic app !

Silvia

jarrod
12 - Quasar
12 - Quasar

did it two ways - one with a simple filter and one that transposes, appends, joins and uses an updated text input action. both have their merits.

Spoiler
jarrod_0-1590003703903.png

 

 

DavidLane
8 - Asteroid

I originally skipped this one as I am not that familiar with app interfaces, but as I have become more involved with macros this seems more straight-forward

 

Spoiler
DavidLane_0-1590064533959.png

 

YomaraA
8 - Asteroid

Here is my solution!

 

Spoiler
YomaraA_0-1590152870279.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590161153699.png

 

balajilolla_1-1590161162760.png

 

G_Thompson
7 - Meteor

My first real stab at an App!

deviseetharaman
11 - Bolide
Spoiler
 
NapasornCh
7 - Meteor

I used a very different approach to the solution to come to the same answers.

 

I chose to create a key field with some parsing and multifield formula involved.

 

See solution in pic and attached.

 

Spoiler

NapasornCh_0-1590936041540.png

NapasornCh
7 - Meteor

To avoid manually set the drop down value

Spoiler

1. Use 4 select tools to rename all the fields to be the same name (e.g. position number, key, etc) and then union these four streams into one column.

2. Use cross-tab to turn this key column into separate field names

3. Feed these field names into the drop down tool

 

 

NapasornCh
7 - Meteor
Spoiler

1. Use 4 select tools to rename all the fields to be the same name (e.g. position number, key, etc) and then union these four streams into one column.

2. Use cross-tab to turn this key column into separate field names

3. Feed these field names into the drop down tool

Above is the method to avoid manually listing the drop down selections