Tableau rolling 12 months axis.

Sherry Dreher Customer asked a question. Here is an example done in excel: Is something like this possible in using a calculated field and still charting it as a date? Finding out how many members are requesting jobs per month is easy enough- I use a countd memberID and put request month in to columns. See attached. To get the YoY we can use the quick table calculation of Percent Difference. And yes, is only one month, so you want to force the TTM value in there.

 

Hi, I have a basic Area chart that represents a rolling 12 months, so the visual start and end dates will change each month.That calculation will sum up the TTM if the date field is expanded to the month level but if you look at the picture what I want to do is show the dates at the year level and have the final "year" be calculated as TTM.

 

I am trying to create a TTM (trailing twelve months) line graph assuming today is (05/20) but I am getting data from 01/19 to 12/ Anyone.Sean Murphy Customer asked a question.

 

Ideally I will like to look a this in a line graph, where the X-axis hast the months (January February March) and the Y axis has the frequency .You could start by looking at this thread to see if it meets your needs

 

Hello All,. I have a date dimension that I display in each column as the year but the data behind it is at the month and year level.But I've attached a solution, and it'd be tricky without talking to you or showing you with your own data.

 

5//31 and it would be rolling forward as each month from the current fiscal year happens). Here is an example done in excel: Is something like this possible.Using Version

 

forum? I need to show a daily trending chart with dual axis, one axis would have Rolling Time Period (12 months/6 months/3 months) selected from a 'Rolling Period'.Thank you!

 

Tableau customers, thank you for your patience as we address the Apache Log4j2 vulnerability. As we continue to monitor this issue, please visit.Does this help?Forum Tableau rolling 12 months axis

 

ELSEIF [Month Index] > THEN 'Last Year Rolling 12 M'. END. and then one final bit is to allow me to plot both Decembers on the same axis.Hi - sorry to intervene - they are not in the data source as noted in his original post and is why he needs to scaffold the data to do what he wants as noted in my original answer note I also spoke on this on an upcoming Data Doc to be posted on Vizconnect Jim.

 

However, I don't want to show the rolling 12 month average data points Please select Dual axis In the chart and that should show both in.I am encountering the same issues.

 

Consider the following data, I am trying to build a chart with year-month (Date field) on X axis and plot a metric on Y axis based on the formula like this.I am using the Superstore data here.

 

But I'm struggling to work out how to display how many members have made a request within the last 12 months.

 

S1 X6.

 

Log In to Answer.

 

I have data for a month period Jan - Apriland I want to graph both the monthly data points as bar graph and the rolling month data points as line graph.

 

Related Conversations Nothing found.

 

We have a fiscal year starting in October where I work, and we use this approach all the time.

 

Thanks again.

 

If I want to pull that dimension into the workbook but also to have it show two additional columns for the past 12 months and the previous 12 months, how is that done?

 

Here's the data in 2 separate graphs:.

 

Item Year-Month Sales.Forum Tableau rolling 12 months axis

 

My thought was you wanted something like the following: Are you saying you just want the label "Current 12 Months" to be shown on the axis as well?

 

Raghu Reddy Customer asked a question.

 

Sherry Dreher Customer asked a question.

 

Let me know if this makes sense.

 

I can supply a workbook if needed, but I'll have to generalize some data first.Forum Tableau rolling 12 months axis

 

Hello Rene, Thank you so much for the explanation.

 

Rolling 12 month window.

 

There are two LODs in that one calc.

 

Darren, Did you solve this?

 

View This Post.Forum Tableau rolling 12 months axis

 

But I'm not really sure what your end viz goal is.

 

Note: The best approach would be to actually calculate this number to be a percentage of the max value on your actual chart, but you get the idea.

 

Ask a Question.

 

Sean example A.

 

Hi guys, Vivan, you're trying to count distinct Users over moving window where repeating occurrences of Users may exist.