Issue#26: Tableau - envoke calculation for records between date parameter

  • I have two parameters for the user to select a Start and End date.


    for all the records between these two days, I would like do a calculation (let's start with the total of sales - but in the big picture, I have a number of calculated fields that I would like to "run" for only the records between the dates selected in the parameters).




    thank you.

    0 Answers

    Sorry, your answer is too short !

  • Issue#380124: Tableau - Calculation for total using date parameter

    Hi All,  I hope you are well. I've got myself really stuck with a calculation on a workbook and wondered if you can help. Basically I want to produce a display that has running totals of 2 values over time - one is based on cost and the other on energy usage in 4 locations. I've managed to get the cost part of the panels change in value depending on the date range picked, however I'm really stuck on being able to do this for the energy part of the board. I've attached a workbook where I've tried lots of different things. I've used an LOD calc on the energy part that was kindly given to me on this forum. However this fixes the value between min and max dates on the workbook. If possible I would like the energy readings to change based on date range the same way that the cost part does. I then looked at using date parameters instead but have been unable to get anything with parameters to work. Really hoping someone can help out with this one.   Scr

  • Issue#8: Tableau - Calendar date parameter

    I need to count a number of open Help Desk incidents for any single day during any date range.For each incident I have Date_Opened and Date_Closed.I want to create a Calendar Date parameter, for each day in a date range I need to calculate the number of incidents, that have been opened before this day and either closed after this day of never closed. Please let me know if you have any ideas.Thank you,Hannah

  • Issue#14821: Tableau - Need help with calculation and deciding between Parameter and Calculated Field

    Not sure if I have to create a Calculated field or a Parameter yet.But, first I need help with the below calculation. CASE WHEN Column1 = 'A' THEN 'Yes' ELSE 'No' END + '  ' + CASE WHEN Column2 = 'X' THEN 'Alpha' ELSE 'Beta' END So, the result will look something like this; When Column1 = A and Column2 = X,Answer will be - Yes Alpha  When Column1 = B and Column2 = Y,Answer will be - No Beta    Note : All the columns are from the same data-source(Teradata). Sorry , but I cannot attach any worksheets here.   Any help is much appreciated. Thank you in advance. --RAJ--

  • Issue#63906: Tableau - Change date axis based on a parameter

    I have a chart that shows sales over time. I have 3 sales measures (which I cannot change) that are current sales, QTD sales, and YTD sales. I have successfully created a parameter and a calculated field that pick the right measure depending on if the user selects current, QTD or YTD. The problem:My x-axis (date field) doesn't change to reflect the time period. Is it possible to have the x-axis only show month when current, quarters when QTD and years when YTD? Can I do this the same way as I did for my measure if I create custom date fields? Thanks in advance!

  • Issue#73981: Tableau - Month over month and Year over year calculation with arrow up down-with date filter

    Hi,I have been searching for answer to what I want to do.  A lot of thread came close to what I need but not quite.  I saw a lot of samples to use table calculation on what I want to do but table calculation doesn't allow me to be able to use date as filter.  Basically, what I want to show on dashboard is a simple table that looks like this. I don't want to show date on the row but rather show some other dimension so table calculation won't work.  Also, I want to be able to just filter by month. Any help or suggestions are much appreciated.Thank you

  • Issue#126310: Tableau - Parameter Issue

    Hi All, I got issue with parameter where iam trying to find 'sales' of Sub-category for Last >15days,>30days,>45days from today date. So i created a parameter for 15days,30days and 45days and i wrote calc like if [Days] = "15 days" and DATEDIFF('day',TODAY(),[Order Date])< 15 then "Show"elseif [Days] = "30 days" and DATEDIFF('day',TODAY(),[Order Date])< 30 then "Show"ELSEIF  [Days] = "45 days" and DATEDIFF('day',TODAY(),[Order Date])< 45 then "Show"ELSE "Hide" END  but above calc is not affecting view and i attached twbx file so can someone pls look into my issue and correct me where iam making erro (twbx file is in 9.1version)  Thanks

  • Issue#127271: Tableau - Change date level with parameter

    How can I create a formula that will show me 2 years,1year,Since Jan, Last 30 days as a filter or parameter that will be applied to values/measures in a worksheet

  • Issue#132656: Tableau - Parameter filter to current date

    Dear All, In my workbook, I used date (mm/dd/yyyy) as a parameter filtering. The date is not update to the current. I want it to update automatically, without opening the workbook and select the current date and export again.Is it possible? pleas share some suggestions. Thanks,Vanndy

  • Issue#174951: Tableau - Rank calculation issue

    Hello Friends,Quick question here- On the attached, I'm trying to display the top N customers based off my parameter "Top Customers 1". Everything seems to work correctly until I begin to filter my view. For instance, if I select "STS" instead of "All" on the Business Segment quick filter, Tableau doesn't display the specified number of customers based off my Top Customers 1 parameter. Any idea how to resolve? Regards,Mikey

  • Issue#176979: Tableau - Date Calculation

    Hi All , I have one requirement, if I select Jan form moth filter then view should have data  for dec ..means view should show previous month of data  from selected months( excluded) .I have month in string formate not in date formate & I am bot keeping month in view will be in filter  only .   Please anyone provide input ..Thank you

  • Issue#204760: Tableau - Parameter control date as Day/Week/Month

    Hi All, I am using date as Discrete value, and created a paramter to control the aggreation value based the parameter selection. Like if the value in the Parameter is selected Week, output should show the sum of Week of that particular Week. So at a time one Week value will be shown.  Regards,Manish

  • Issue#218229: Tableau - Date filter created with table calculation applying to multiple sheets

    I have created a dashboard with two worksheets (two maps, as in USA/Alaska) and three filters. I want those three filters to action on both sheets. I can do it with two of them with the Apply to worksheets.. option. But for the third one, as I used it for years to get difference between values, I created it with a calculated field LOOKUP(ATTR(YEAR([Date Order])),0). So there is no Apply to worksheets option. So the USA map applied year is selected with that filter, but Alaska remains in the first one. Any workaround?  Thank you so much.

  • Issue#278023: Tableau - Creating Date Parameter Filter

    Hello, Can anyone help to create a date filter which changes dynamically when the data source gets updated.Where i dont need to select the date manually. I need to change to the max(date) in the data source Below is a screenshot for superstore date.I need to create dynamically changing date filters to our organization business reports. Please help me out.Thank You  Example.A date filter is created for order date 31/12/2014 and i want the same filter to get update when the date to 10/01/2015 when  new data is being added.    

  • Issue#328644: Tableau - Parameter Maximum date from field on server source

    I have several calculated fields that I am using to determine if data fits into a rolling periodi.e. Rolling 2 months  isDATEADD('month',-2,[Max date in Discharge Date FY]) <=DATETRUNC('month',([Discharge Date FY])) AND [Discharge Date FY] <=[Max date in Discharge Date FY] The calculation is currently referencing a parameter set up like this:The downside is that each month when the data source (on a tableau  Server) is updated, I have to come in and manually change this value. I was looking for a way to get it to do that automatically and have an idea but wondered if anyone thinks it will work. If I change that parameter to be set to:Where I chose "Set from Field" and selected a date field in my source. Would it always register as the current max date or when the data source is updated will the parameter know to read the maximum date from the field and thus pass through the right date to my calculated fields?  I hope I explained that clearly.

  • Issue#331275: Tableau - Date and Drop/Gain of counts calculation

    Hi Guys, I have a data set  and need your suggestions on how can i show the data from Friday to Monday for every week. So on Saturday it should start showing next week's Fri to Monday data. I also what to add what are the drops/gains from prior day if that's possible. An arrow indicator pointing drops/gains would be great. I tried relative date and did not work. Can you please suggest on how to get these in the format requested? Thanks for your help,JC 

  • Issue#339632: Tableau - issue with CAGR calculation

    Hi All, we have create a CAGR calculation by using Lookup(): (LOOKUP(SUM([Month Totals]),LAST())/LOOKUP(SUM([Month Totals]),FIRST()))^(1/(SIZE()-1))-1 Formula will only work, if all years are visible.Now I am searching for a way, how to adjust the formula to be able to display only a few years.Can I refer to value for 2012 and 2016 and also lookup the specific years instead of using SIze() within formula?  Thank you very much in advance for any hints. Best regardsSabine

  • Issue#370107: Tableau - Dynamic Score Calculation based on multiple Parameter

    Hello, We have requirement for one of the KPI/Score card dashboard. So working on this POC, need assistance in dynamic score calculation based on 5 parameters In the report we have 5 parameter based on which the score will be calculated, the total score should not be more than 100% Please find attached sample dashboard - There are 5 Parameters and 5 Metrics, current I have kept the parameter as Type in- User will change value of parameter based on his/her requirement which will be from 1 to 100, e.g. If they change value of P1 from 20 to 15.  The value of P1 metric score should be 15 and all the other metric from P2 to P5 should get the reminder value i.e. 5  (20-15) Can you please suggest some solution

  • Issue#376311: Tableau - Latest value calculation by customer id and date

    From a set of customer data, I'm looking to find the last purchase in 2015 and the last purchase in 2016 and find the difference between the two. For example, in the attached workbook customer 5687 made two purchases in 2015 ($114.11 in February and $100.98 in August) and one purchase in 2016 ($82.88 in March). What I'm looking to accomplish in this example is to calculate $100.98 - $82.88, and for that same calculation to happen across the entire dataset. In some cases, customers will only have purchases in 2015, and in other cases customers will only have purchases in 2016. Any help would be appreciated. Thank you! Joel 

  • Issue#461640: Tableau - Current Date on Parameter

    Hello, I want a parameter to display today's date by default but I do not want to restrict the user with a list of dates or one single date as I went through other possible workarounds for the same question.Re: How to set data parameter to Current Day RegardsGatik

  • Issue#462940: Tableau - another open/close date issue: overdue tickets, aka count # of tickets open more than X da

    Hi all, I've spent the last few days working on trouble ticket data, using the excellent FAQ on open/close dates.  But, I've got a twist on the issue that I can't figure out.  I can count the number of open tickets, but I also need to count the number of tickets that are open, and have been open more than X days (where X will likely be 14 and 90, but which is 2 in the attached for simplicity). I've attached a simplified workbook to show what I want.  the basic open tracking sheet is working for open ticket.  If it was working, I would want another page that would show 1 overdue at the end of 1/2, 2 at the end of 1/3, 1 on 1/4, 1 on 1/5, and 0 on 1/6.  the actual data source will be an SQL database, but I'm using excel for this example. Since i have to track this at the individual ticket level, I'm not sure how to track that over time, or how to handle dates that don't exist in the data, like 1/5.  Any help would be REALLY helpful. I've been

  • Issue#472546: Tableau - Max Date set by Parameter

    Hi,I am working my way through a problem and am going circles trying to solve it with different outputs. I have set my data so that I have a parameter that allows me to choose the level of the report I want to view, i.e. day, week, month, quarter, year.When I make that selection week for example, I just want to see the calculation at the level of the latest week, with the week  display format in place, and so on for the selection. I have tried the using max() date, but it converts to a measure and I can't apply this to a filter. I have used fixed LOD, but I am not getting the results I am expecting this is the calculation that I am applying Latest Date Calculation  case [Date Level Selector] */ This is my parameterwhen "day" then {fixed :DATETRUNC('day',max([Created]))} /* Created is the date fieldwhen "week" then {fixed :DATETRUNC('week',max([Created]))}when "month" then {fixed :DATETRUNC('month',max([Created]))}when "quarter" then {fixed :DATETRUNC('quarter',max([

  • Issue#499975: Tableau - Setting Multiple Date Ranges for a Calculation

    Hello, Is it possible to have a calculation run based on different parameters and show each of the results in a table? Right now we have a list of what we consider to be a "Lost Customer", however we would like to track the units purchased from the month which they were considered to be a lost customer, which would be 0 to the months where they purchased units. I would like to calculate a lost customer at different intervals. So for example, lost customers at 1/1/2016, 2/1/2016 and 3/1/2016. We do not worry about days, only the month of purchase.  So I am trying to figure out if I can run a calculation based on a max date range each time.  Is there a way to set a "Max Date" for a calculation to run on? This is the formula for a lost customer: - the ordering factor is just a buffer.  So if a customer orders every 3 months on average, if the ordering factor is set to 2, it will look to see if that customer has not ordered in 6 months. IF ([# Times

  • Issue#575915: Tableau - Filter to show last x records based on date

    Hi - apologies if this is a straightforward question but my 2 hrs of googling hasnt been successful.  I am looking to put a filter in to show only the last x records from the most recent record date. The dataset i am using (salesforce opportunities and activities) brings in all past activities for each opportunity. Some have 20+ activities which makes it hard to look at so I would like to only show the most recent 3 or 5 activities related to that opportunity.MAX date filters it fine on the subject (some have the same subject) but ultimately when i expand out that it brings in all the other activities.(couple of screenshots below and table to indicate how i currently have it laid out Was hoping to put a filter in to simply say "Give me the last x records based on the most recent date" any help greatly appreciated  With the max date filter  when subject is expanded out to reveal more detail (brings in all tasks)Perfect world would just be most recent  

  • Issue#576965: Tableau - Date Parameter

    Hi Guys, I have a worksheet that I am using to compare the data by year, month, week and day. I have created the parameter for select start and end date.After users select the products and selected dates for comparison, they also want to have the flexibility of comparing the data by year,month week and day.I have issues with combining the functionality for user based date selection and viewing data by year, month,week and day. Can you please suggest any ideas? Below is a screen shot - Thanks,JC

  • Issue#589911: Tableau - Custom Date showing values in Running Total for future months in YTD calculation

    Hello, I have a complex problem, which I am hoping someone can help me solve. I attached a workbook that uses the sample data set to help illustrate the problem. Here's the scenario: I am using a date, which has a fiscal year that starts in October. However, sometimes the data needs to be displayed by the actual calendar year, so I created a calculated date from the Order Date (called 'Order Date (Fiscal)'). I then need to create a YTD calculation based on the Order Date (Fiscal), but in order for the calculation to function properly with the fiscal year, I created 2 additional dates using a DATEADD function that add 3 months to the Order Date and TODAY(), titled Fiscal Date and Fiscal Date Today Respectively. The two YTD calculations are titled 2014 YTD Quantity and 2013 YTD Quantity. I have the two YTD calculations on a line graph over months of the year with a running_sum table calculation applied. My problem is this; the line graph extends through June, July, August,

  • Issue#592442: Tableau - Year over Year Calculation via Date Parameters

    My Business Need has me perplexed as to how best achieve year over year analysis with an adjustable date filter. We want to see what categories have grown by a custom year over year date range specified by the user. Our business model is retail, which means local events can affect traffic and volume more than national, date specific events (i.e. beginning of the fiscal quarter). Attached is example of what I am doing, I may be approaching this the wrong way. I have looked through many posts and have not identified a need similar to mine which would address this. I also met with a "Tableau Doctor", though that individual was not a real help outside of suggesting parameters over straight date filters. The Filtered tab allows the user to select the date range with the data structured similar to how it feeds into our Tableau Server Datasource. The Prior Year tab shows 2012's numbers and Current year tab shows 2013's. My goal is to get (if filtered to 1/1/2013-2/28/2013 via Parame

  • Issue#609282: Tableau - Fiscal Date through True or False calculation

    Hi Everyone, I've been struggling with calculating Fiscal YTD, QTD and MTD for my reporting (Calculation I need include: Fiscal YTD, QTD, MTD. Previous QTD and MTD, Prior Year YTD, QTD and MTD)I read numerous forums and still wasn't able to make it work.The problem is my Fiscal month is not equal to calendar month and may have anywhere from 27-35 days in it. For example April has 28 days and June has 35 days in it.So far I've been using today () as my comparable period but due to a different fiscal month structure it's not working the way it should be. My fiscal year starts in Fiscal month of April.Attached is excel file with all Date dimension i created in Tableau.I'm looking for something that would allow me to create YTD, QTD and MTD as True or False calculation like below: Fiscal YTD: year([Fiscal Date])=year(dateadd('year',1,today()))And  [Calendar Date]<=today() Thanks a lot for your help with this! Olga

  • Issue#614495: Tableau - Trying to produce a list of records at a date, based on entries in 2 date fields

    Hi, I hope someone can help. I've been told to use Tableau to produce a report listing email addresses for people in a particular placement (job role at a particular site, essentially) at a date the user selects. Eg, someone might want a list of people and their email addresses for people in placements at 1 April 2016. Or 31 July 2016. Or 1 January 2016 for that matter. So we want to put a report on the server which allows them to access the report, select a date they want to see data for, and return the results which they can then export into Excel.  I know Tableau is perhaps not the most appropriate reporting tool for this task but its all we have for now. I have a dataset of 70000+ rows (the packaged workbook attached here has only a small set from this) with people and their current placements going back several years. There's a location, start date and end date for each placement, as well as the name and email address of the person concerned (along with lots of other col

  • Issue#621139: Tableau - Dateparse calculation for mixed date format

    I have a date format that I'm struggling to convert. It's a dateparse but I don't know how to convert the "month". Any help would be greatly appreciated.  Example: 13/Ene/2016. The "Ene" is spanish abbreviation for January.