Hello All,
I am hoping to create a workflow that can utilize dynamic reference lines (average or median) and logarithmic X axis in a data visualization.
I know this can be done quite simply in tableau but I would like to have it done in Alteryx. I have attached the visual in tableau that I created (to model after / look very similar to).
My end goal is to have a workflow that can create a data visualization that looks as close to my tableau visual as possible.
I have attached a screenshot of my Tableau visual, my spreadsheet dataset, and my current workflow that needs fixing.
Any ideas on how to accomplish this? Thanks!
| Brands | Visits | ranked in CBSA | # of locations in CBSA | Percentile |
| Barnes & Noble | 201,100 | 7 | 9 | 28 |
| Portillos | 422,400 | 2 | 3 | 50 |
| Flower Child | 293,500 | 1 | 4 | 88 |
| Frys | 965,300 | 60 | 95 | 37 |
| HomeGoods | 450,700 | 4 | 7 | 50 |
| Marshalls | 443,800 | 3 | 10 | 76 |
| DSW | 165,400 | 5 | 7 | 36 |
| The Home Depot | 800,300 | 21 | 36 | 43 |
