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 #208: COVIZ-19

Highlighted
Alteryx

A solution to last week’s challenge can be found here

This week - let's do an interesting viz! We have sourced the RNA sequencing of SARS-CoV-2 (which is responsible for COVID-19) and would like to put it into a gridded visualization.

Since RNA is made of up the base pairs of G,T,A, and C, your visualization should have four colors. When creating the grid, try to order the sequencing from left to right: For example, the first base pairs are A-T-T-A. Make sure that A is row 1 column 1, T is row 1 column 2, and so on...

Make note of how many columns make up a row or what colors you select are entirely up to you (our solution has 178 columns)!

If you want to take it a step further, let's see if you can create something new entirely!

Data sourced from: https://www.ncbi.nlm.nih.gov/nuccore/MN908947.3

Highlighted
16 - Nebula

I went for a black and white pattern

Spoiler

Alteryx Partner

Took me a few tries to land on this solution. Glad to see that my thought process matched @patrick_digan's excellent first solution.

Spoiler
Weekly Challenge 95 (the apple one) helped here.
The .4 mile grid was found iteratively: it provides the nearest larger number of grids than we have rows in the tokenized data set.

https://youtu.be/lxCS3vs1Bwk

208] I Can Alteryx That: COVIZ-19 In this edition of I Can Alteryx That, we present a solution to weekly challenge #208, where we create a visualization of ...
Highlighted
Alteryx Certified Partner

Certainly a topical weekly challenge:

Spoiler
Highlighted
Alteryx Certified Partner

Stuck indoors is a good time learn some Python

Spoiler
outputworkflow

Code

Highlighted
Alteryx Certified Partner

I have chosen a slightly different (and relatively simple) approach.

Spoiler
Spoiler
Highlighted
Alteryx Certified Partner

As a molecular biologist, I think that this is a good challenge to get to know Alteryx and reporting but it holds no additional value.

Result in Alteryx

Spoiler

Result in Tableau

Spoiler

Workflow:

Spoiler
Highlighted
Alteryx Partner
Spoiler

Not 100% sure if I've approached this correctly but here's my video solution for it: https://www.youtube.com/watch?v=0RuHrWjVtWs&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=13&t=0s

This week we're building a heatmap in Alteryx using COVID-19 data. Find the challenge here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-208-C...
Highlighted
14 - Magnetar
Spoiler

Highlighted
Alteryx

My solution attached. Went a different route from most of the other solutions I've seen.

Spoiler
I tried the grid approach and it worked but seemed to take a long time (15 seconds or so). So I went for brute force and this runs in two seconds or less.Still can't figure out why the grid approach was slower but I saw the same thing when I downloaded some of the other solutions.