1 of 1 people found this helpful
Without knowing exactly how your data is set up, you will be able to solve this with a combination of REFERENCE LINEs and TABLE CALCULATIONS. Reference lines allow you to draw horizontal trend lines. Table calcs allow you to work with any value of any mark or marks on your view. There are quick start guides on both of these areas: http://www.tableausoftware.com/support/manuals/quickstart
I've attached an example with a reference line showing most recent sales value - a bit simpler than your requirements, but i hope you get the idea.
Thanks Andy. This is not quite what I'm looking for. In the case of most recent sales, the view would be a line chart of "most recent sales" (aggregated weekly) but the reference line would be the YTD weekly sales volume.
Basically the question this would answer for someone looking at the view (and maybe this will inspire other graphical solutions): "Okay, I see that this chart for the past 5 weeks shows sales declining a bit. But the values themselves don't mean much to me because the program has been fluctuating so much this year. I wish this graph had a reference line in it that would tell me, in the year 2013, what we could expect (on average) of sales during an "average" 2013 week. This would give me a way to say 'OH okay, sales are fluctuating in line with YTD values, so slightly above and below that means things are as normal. If the sales line was wiggling far below this reference line than I know I have to call the sales team and yell at them."
All this requires is a table calculation of YTD values that are not in your view. Does tableau make this possible in a single view?
- Duplicate your data source
- Remove all linking fields
- In the copy of the data source create your CTR calc: (SUM([Clicks]))/(SUM([Impressions]))
- Put this on level of detail, and add the reference line as MAX or AVG or MIN (but not SUM).
PS: The data in this workbook is sensitive, but since I took 5 minutes to remove the names, and scramble the media costs, I am able to share it with you. In the future you can do the same.
Marc.twbx.zip 61.8 KB