Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

COVID-19 Totals/Github

8 - Asteroid

Hello All:


I have the attached flow that was modified to pull data from the JHU website and combine the three data sets.   I have been trying to add a Summarize feature to sum the totals by country and province for Confirmed, Deaths and Recovered cases.  I have not been able to get it to work and maybe one of you wonderful people could provide a solution. 


The data is changing daily and it would be helpful for my purposes to add the new data daily as well.  


Thank you so much!! 



Alteryx Certified Partner

Hi @bcampbell0621, does adding a summarize tool to sum numerical value by country and province at the end of the workflow, and joining in back to the base data work? Something like the attached solution? Please let me know if I misunderstood the ask.

8 - Asteroid

Hello @AbhilashR and thank you for responding:


I think we are closer to the right solution, but we need to figure out how to sum the totals for reach case type for each country.  I added a mock up of what the flow should produce.  I hope this helps and makes sense. 


Thank you!

6 - Meteoroid

Hi @bcampbell0621 - please see my workflow attached. This uses Python pandas to generate a data frame from the daily report csv file on JHU's GitHub site. To get the most up to date data - you'll need to change the date in the url string in the Python tool i.e (change 04-04-2020 to 04-05-2020) to get the data that is posted tonight and so on. Hope this helps, please let me know if you have any questions, thanks.