3 Replies Latest reply on Oct 15, 2018 3:35 PM by ShivaRam Chennapragada

# baseline chart

I wonder how to create a baseline chart. I have the dataset of nfl, now we have the selected players filtered appropriately. I have never created a baseline chart, just wohder how to do it? Its supposed to base x axis as 1,2,3,4....11(for 2006 till 2016) and players data have to be shown as all starting from 1, suppose somebody started from 2009, then played in 2012, 2016, so the corresponding points for that player should be on 1(corresponding to 2009),2(corresponding to 2012) and 3(corresponding to 2016). Similarly for all players.

I can create a calculated field from 1 to 11 based on 2006 to 2016, but it wont create baseline for the players. Any idea will also be great, I can work out the rest.

Thanks a lot,

• ###### 1. Re: baseline chart

Arnab- Your questions look like homework to me, are you making us do it?

• ###### 2. Re: baseline chart

Hi Shiva Ram, I am learning Tableau from some sample exercises, and in that process I get stuck, yes, my questions might sound like a bit stupid like my earlier question which I was struggling with a core concept. Thanks to community, I learned a lot, I am trying a lot, getting stuck sometimes, but do you think criticizing help here? I asked some pointers even, not the entire solution, so that I may learn in the process.

Thanks a lot.

• ###### 3. Re: baseline chart

I wasn't criticizing, sorry if it came it across that way. And no, your questions weren't stupid. I learned a lot here too.

Coming to your question, I haven't worked on baseline charts but here is a viz by Andy Kriebel that I found and looks like he utilized similar NFL dataset to build a baseline chart. You could download the workbook and break it down on how it was created.

Happy learning.

Best,

Shiva.