Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #5: HR Position Finder Application

SilviaRox
7 - Meteor

Hi there,

this was my first weekly challenge about analytic app !

Silvia

jarrod
ACE Emeritus
ACE Emeritus

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

 

AcevedoYo
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
8 - Asteroid

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