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 #359: Manipulating Dates

nSpire
9 - Comet
Spoiler
nSpire_0-1676964219735.png

 

lvprasad
7 - Meteor

lvprasad_0-1676965714241.png

 

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT_Solution_359.jpg

RWvanLeeuwen
11 - Bolide

 

Designer Desktop

Spoiler
359 desktop.png

Designer Cloud (classic Trifacta Experience)

Spoiler
359 cloud flow.png359 cloud.png
Christina_H
14 - Magnetar

Nice and easy this week, I work with dates a lot!

Sebastian_Chaieb2
10 - Fireball
10 - Fireball

One tool solution

Spoiler
Sebastian_Chaieb2_0-1676970440172.png

 

Chia
5 - Atom
Spoiler
Chia_0-1676972871545.png

 

willemb
7 - Meteor
Spoiler
willemb_0-1676975586362.png

 

ASTHA1111
5 - Atom

Below is the solution for the above challenge in which I have created a formula for changing the date field in the above specified challenge the formula for which is given below.

 

IF

tonumber(right([Date],findstring([Date],"/"))) < 4 then "Q1 "

elseif

tonumber(right([Date],findstring([Date],"/"))) < 7 then "Q2 "

elseif

tonumber(right([Date],findstring([Date],"/"))) < 10 then "Q3 "

else "Q4 "

endif

garvit96
5 - Atom

Solution