Weekly Challenge

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

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

Submit Feedback
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.

Challenge #5: HR Position Finder Application

Highlighted
7 - Meteor

Hi there,

this was my first weekly challenge about analytic app !

Silvia

Highlighted
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

 

 

Highlighted
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

 

Highlighted
7 - Meteor

Here is my solution!

 

Spoiler
YomaraA_0-1590152870279.png

 

Highlighted
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590161153699.png

 

balajilolla_1-1590161162760.png

 

Highlighted
7 - Meteor

My first real stab at an App!

Highlighted
11 - Bolide
Spoiler
 
Highlighted
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

Highlighted
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

 

 

Highlighted
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