Hey there, I've managed to add the week totals using aggregate measure but I still need month-to-date total using running total but I can't figure it out how to add it as a row right under "Week total". Does any one have an idea?Unknown...
To add your quick filter to the dashboard, you just need to create a new dashboard. You can select the single value list option to get radio buttons. Also, the forecast option was grayed out because you were not using a continuous date format, and the table calculation you were using d...
I have a table where I need to subtract two values which are from different rows. I want the difference between the value for the current date in the row and from the row which has the previous month. This is an example where I have the columns Date and Value in my table, but I ...
{MAX(DATEADD('month',-1,[Recent Date Calculation]))} You can treat your parameters as calendars, type in values, or sliders, but you can't do what you want with one slider - you could work out the two months to compare with one, but you can't set the default values of a date ...
I have a month parameter and I want to display the values for one month at a time for which I am using below calculation: [Month] = [Select Current Month] Where Month is Date field from data source and Select Current Month is a list parameter ...
I am trying to compare current month vs prev month for the number of occurrences for a dimension. I have the formula for current month working but the prior month calculation is coming Null. This involves 2 formula's, one date calculation: prior month and a prior month count: Prior Month...
whenever you need to look across rows or columns think Table Calculation first - see the entire series here https://jimdehner.com/bgs-beyond-getting-started-the-path-to-understanding-tableau/ it will take you through the fundamentals you need to understand when first coming to Tableau - then...
I don't understand the question. What does a month have to do with the ranges you listed? UpvoteReply Tableau Community(Tableau) 10 years ago I have a date filter that is looking at a given month so I would like to know based on the timeframes above, how many minutes that would be ...
Is it possible to do a similar kind of calculation once I pivot tables?Also there are 3 time stamps.I am trying to find the avg duration of days spent in each stage per month.How do I match 3 time stamps to one month? I know I have to connect a calendar somehow , but I am e...
I used the following calculation to determine the status of an issue at the end of each month: For cases where the status did not change across months, i'm using previous_value() to retrieve the last known status: Using the above two calculations, this is how...