Tableau rolling 12 months axis.

Discussion in 'after' started by Mazulmaran , Wednesday, February 23, 2022 3:53:01 PM.

  1. Yogami

    Yogami

    Messages:
    73
    Likes Received:
    9
    Trophy Points:
    8
    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.
     
  2. Maujind

    Maujind

    Messages:
    730
    Likes Received:
    4
    Trophy Points:
    0
    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.
     
  3. Kazisar

    Kazisar

    Messages:
    503
    Likes Received:
    3
    Trophy Points:
    0
    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.
     
  4. Samuzragore

    Samuzragore

    Messages:
    202
    Likes Received:
    14
    Trophy Points:
    2
    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
     
  5. Visar

    Visar

    Messages:
    259
    Likes Received:
    28
    Trophy Points:
    6
    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.
    Tableau rolling 12 months axis.
     
  6. Fem

    Fem

    Messages:
    163
    Likes Received:
    29
    Trophy Points:
    4
    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
     
  7. Takasa

    Takasa

    Messages:
    190
    Likes Received:
    29
    Trophy Points:
    3
    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!
     
  8. Mogul

    Mogul

    Messages:
    564
    Likes Received:
    32
    Trophy Points:
    7
    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
     
  9. Shaktigore

    Shaktigore

    Messages:
    887
    Likes Received:
    13
    Trophy Points:
    0
    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.
     
  10. Tygorg

    Tygorg

    Messages:
    115
    Likes Received:
    4
    Trophy Points:
    0
    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.
     
  11. Mikatilar

    Mikatilar

    Messages:
    977
    Likes Received:
    9
    Trophy Points:
    4
    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.
     
  12. Jurisar

    Jurisar

    Messages:
    688
    Likes Received:
    8
    Trophy Points:
    0
    But I'm struggling to work out how to display how many members have made a request within the last 12 months.
     
  13. Akinokazahn

    Akinokazahn

    Messages:
    314
    Likes Received:
    18
    Trophy Points:
    2
    S1 X6.
     
  14. Zolorn

    Zolorn

    Messages:
    714
    Likes Received:
    30
    Trophy Points:
    7
    Log In to Answer.
     
  15. Mejas

    Mejas

    Messages:
    586
    Likes Received:
    6
    Trophy Points:
    3
    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.
     
  16. Mazugar

    Mazugar

    Messages:
    693
    Likes Received:
    11
    Trophy Points:
    6
    Related Conversations Nothing found.
     
  17. Ganris

    Ganris

    Messages:
    867
    Likes Received:
    5
    Trophy Points:
    6
    We have a fiscal year starting in October where I work, and we use this approach all the time.
     
  18. JoJolmaran

    JoJolmaran

    Messages:
    13
    Likes Received:
    17
    Trophy Points:
    4
    Thanks again.
     
  19. Kelkree

    Kelkree

    Messages:
    27
    Likes Received:
    5
    Trophy Points:
    3
    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?
     
  20. Julrajas

    Julrajas

    Messages:
    865
    Likes Received:
    29
    Trophy Points:
    5
    Here's the data in 2 separate graphs:.
     
  21. JoJoll

    JoJoll

    Messages:
    57
    Likes Received:
    15
    Trophy Points:
    7
    Item Year-Month Sales.Forum Tableau rolling 12 months axis
    Tableau rolling 12 months axis.
     
  22. Sasida

    Sasida

    Messages:
    74
    Likes Received:
    9
    Trophy Points:
    1
    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?
     
  23. Daikinos

    Daikinos

    Messages:
    670
    Likes Received:
    20
    Trophy Points:
    5
    Raghu Reddy Customer asked a question.
     
  24. Dosho

    Dosho

    Messages:
    757
    Likes Received:
    29
    Trophy Points:
    2
    Sherry Dreher Customer asked a question.
     
  25. Tygogrel

    Tygogrel

    Messages:
    171
    Likes Received:
    17
    Trophy Points:
    7
    Let me know if this makes sense.
     
  26. Zumuro

    Zumuro

    Messages:
    553
    Likes Received:
    33
    Trophy Points:
    6
    I can supply a workbook if needed, but I'll have to generalize some data first.Forum Tableau rolling 12 months axis
     
  27. Dikinos

    Dikinos

    Messages:
    536
    Likes Received:
    9
    Trophy Points:
    0
    Hello Rene, Thank you so much for the explanation.
     
  28. Goltisho

    Goltisho

    Messages:
    303
    Likes Received:
    10
    Trophy Points:
    7
    Rolling 12 month window.
     
  29. Tojazragore

    Tojazragore

    Messages:
    255
    Likes Received:
    32
    Trophy Points:
    5
    There are two LODs in that one calc.
     
  30. Nalkis

    Nalkis

    Messages:
    997
    Likes Received:
    23
    Trophy Points:
    0
    Darren, Did you solve this?
     
  31. Kazralkree

    Kazralkree

    Messages:
    604
    Likes Received:
    16
    Trophy Points:
    5
    View This Post.Forum Tableau rolling 12 months axis
    Tableau rolling 12 months axis.
     
  32. Kagaramar

    Kagaramar

    Messages:
    637
    Likes Received:
    23
    Trophy Points:
    3
    But I'm not really sure what your end viz goal is.
     
  33. Tozahn

    Tozahn

    Messages:
    944
    Likes Received:
    18
    Trophy Points:
    7
    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.
     
  34. Kalar

    Kalar

    Messages:
    237
    Likes Received:
    3
    Trophy Points:
    5
    Ask a Question.
    Tableau rolling 12 months axis.
     
  35. Akir

    Akir

    Messages:
    132
    Likes Received:
    6
    Trophy Points:
    1
    Sean example A.
    Tableau rolling 12 months axis.
     
  36. Tusar

    Tusar

    Messages:
    424
    Likes Received:
    29
    Trophy Points:
    0
    Hi guys, Vivan, you're trying to count distinct Users over moving window where repeating occurrences of Users may exist.
     

Link Thread

  • Quran arabic text in telugu

    Shakak , Friday, March 11, 2022 5:11:33 PM
    Replies:
    25
    Views:
    5257
    Mikinos
    Sunday, March 13, 2022 1:29:52 AM
  • Mx10 firmware upgrade

    Vudal , Saturday, March 5, 2022 2:26:46 AM
    Replies:
    6
    Views:
    2515
    Taum
    Saturday, March 5, 2022 12:15:52 PM
  • Next js hmr

    Mazurg , Sunday, February 27, 2022 4:04:33 PM
    Replies:
    18
    Views:
    4716
    Arashikree
    Monday, March 7, 2022 2:38:49 PM
  • Green dot promo codes 2019

    Zulujinn , Wednesday, March 9, 2022 10:54:55 PM
    Replies:
    15
    Views:
    2536
    Nibei
    Friday, March 11, 2022 11:07:57 PM