Data Visualization with Dynamic Reference Lines and Logarithmic Scale

[wkluvo]

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

[Qiu]

@wkluvo 
I tried to play around and also did not get any luck.