Get this guy some coffee, he keeps calling Trend Lines: Reference Lines.... 🤷🏼♂️ On a serious note, I wanted to cover trend lines for this series over reference lines as they are more complex. Once you understand trend lines, reference lines are super simple to create and you just utilize a value (such as a parameter) to mark a line on your visual. Try both out!
@LukeBarouse I see this was done 3 years ago, so I hope this comment finds its way to you. Simple problem to visualise which I thought the use of parameters may come in handy. I need to sell reports. 1. There is a preparation cost (or sunk cost) independent of the units sold, (so we need a graph for break-even point 2. The sunk cost is spread over the number of expected units sold 3.. Every report is edited to be bespoke per client that buys it (i.e. using their logo, company colours etc), so it is a fixed amount incurred as and when a unit is sold. 4. Sale price per report is fixed. 5. Cost of sales = (fraction of sunk cost based on expected unit sold) + Bespoke editing and analysis Additional info: 1. Total sunk cost is based on hours spent to finish this phase, and a hourly rate 2. The additional cost incurred to prep each report is also calculated on an hourly rate and expected hours spent. So break even point needs to be visualised. Looks complicated when writing it out but it's pretty straight forward.
Thanks to your tutorials; Any fledgeling Data Scientist will learn how to rapidly conduct Data Analyses & beautifully visualize "BIG" Data in Tableau. BTW; Your pace & eloquence are appreciated by Non- English native speakers. Can you please make a Crash course about "Data Mining" using Tableau? THANKS IN ADVANCE!
@@mustaphaelouahabi9316 I appreciate the feedback. In my day job I work with customers from an international audience, so I try to be mindful of that. I'll keep track of the data mining for the advanced series of Tableau that I'll be doing. Thanks again!
This is helpful video but i have a questions Category and Sub-Category into the column and sales into the row and use the Avg line pane wise and i want to define as below Avg line it's in Red colour above Avg line it's in green colour how we can achieve that scenario based Question?
is there a way to make the average line a function of the value? e.g the value i plotted includes negative values, but i want the average line to show the average of its absolute value.
@@LukeBarousse yes. in the end the only way to do it was to put the calculated field on a dual axis and then set the calculated field to no colour so that it had the plot of the original but the line of the calculated version. my trouble was in trying to get the line but without the plot of the new value
Get this guy some coffee, he keeps calling Trend Lines: Reference Lines.... 🤷🏼♂️ On a serious note, I wanted to cover trend lines for this series over reference lines as they are more complex. Once you understand trend lines, reference lines are super simple to create and you just utilize a value (such as a parameter) to mark a line on your visual. Try both out!
@LukeBarouse I see this was done 3 years ago, so I hope this comment finds its way to you.
Simple problem to visualise which I thought the use of parameters may come in handy.
I need to sell reports.
1. There is a preparation cost (or sunk cost) independent of the units sold, (so we need a graph for break-even point
2. The sunk cost is spread over the number of expected units sold
3.. Every report is edited to be bespoke per client that buys it (i.e. using their logo, company colours etc), so it is a fixed amount incurred as and when a unit is sold.
4. Sale price per report is fixed.
5. Cost of sales = (fraction of sunk cost based on expected unit sold) + Bespoke editing and analysis
Additional info:
1. Total sunk cost is based on hours spent to finish this phase, and a hourly rate
2. The additional cost incurred to prep each report is also calculated on an hourly rate and expected hours spent.
So break even point needs to be visualised. Looks complicated when writing it out but it's pretty straight forward.
Thank you so much! That average line is exactly what I need.
Heck yeah!
👍👍👍👍
Thanks Luke for this insightful tutorial!
Your tutorials are to-the-point!
Heck yeah, thanks my dude! Trying to slowly incorporate some of your previous recommendations. I appreciate the motivation!
Thanks to your tutorials; Any fledgeling Data Scientist will learn how to rapidly conduct Data Analyses & beautifully visualize "BIG" Data in Tableau.
BTW; Your pace & eloquence are appreciated by Non- English native speakers.
Can you please make a Crash course about "Data Mining" using Tableau?
THANKS IN ADVANCE!
@@mustaphaelouahabi9316 I appreciate the feedback. In my day job I work with customers from an international audience, so I try to be mindful of that. I'll keep track of the data mining for the advanced series of Tableau that I'll be doing. Thanks again!
This is helpful video but i have a questions
Category and Sub-Category into the column and sales into the row and use the Avg line pane wise and i want to define as below Avg line it's in Red colour above Avg line it's in green colour how we can achieve that scenario based Question?
The average & 95%CI feature frustrates me because Tableau does not give an option to create this based on a weighted average!
is there a way to make the average line a function of the value? e.g the value i plotted includes negative values, but i want the average line to show the average of its absolute value.
Yeah, if you wanted to fine-tune these types of values more, than a calculated field would help in this scenario.
@@LukeBarousse yes. in the end the only way to do it was to put the calculated field on a dual axis and then set the calculated field to no colour so that it had the plot of the original but the line of the calculated version. my trouble was in trying to get the line but without the plot of the new value
ends every other sentence as if asking a question. way too annoying to keep watching