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,


    0 Answers

    Sorry, your answer is too short !

  • 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.

  • 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#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#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#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#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#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#491653: Tableau - Fiscal date reverts back to calendar date with refresh-

    I've got my workbook looking just right by setting the fiscal year start on the date dimension to August.  The fiscal date start seems to get wiped out with data refresh.In this case, the TDE file is machine generated and auto-published to server. Any ideas how I can keep the fiscal date in my workbook?

  • Issue#567243: Tableau - Issue with Calendar Month vs Client Month

    Hello All, We are facing issue with Calendar month Vs Client Month. Please find the below screenshot.    As per the client month, 1st may comes under April but as per the calendar it comes under May month. we have kept a logic to calculate Prorata sales. Month(Client month)=Month(today) then sales. But as per this logic, 4<>5 . I place of month(today) we need to use Client calendar. Kindly help us out. Regards,Koushik.

  • 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#715551: Tableau - Pass today() date parameter in url

    Please help with the following. I have tableau 9.1 tabcmd get "/views/MiracleDashboard/MiracleDashboard?Region=East&Start%20Date=2016-04-21&End%20Date=2016-12-31" -f "C:\AutoTemp\miracleEast.pdf" The above line works only when using hard coded dates. My problem is trying to pass today() and or today()+2 Does anyone know how I can do this. Please help.Thanks for reading and helping.

  • Issue#759543: Tableau - Date Parameter with another Dimension

    Hi All, I am trying to create a parameter which can show data in Quarters or any other dimension selected. I am trying to achieve this in a single worksheet to avoid performance issues. I have attached a sample workbook and tried to create parameter containing Date and Segment.    The problem that I am having now is when the user selects "Segment" we see a null value. How can we do this with out the null value. Any ideas?Thank you for looking through my question. Regards

  • Issue#781380: Tableau - Date Selection parameter and Date filter: Change format of values in date filter based on

     Sorry, I'm terrible with titles. I have a parameter that allows me to change the view levels of a bar chart. The levels are: Fiscal Year, Quarter, Month, Day. I also have a calculated field used to filter dates. For example, if I select 'Fiscal Year' on the parameter, the date filter values become 'January 1, 2011', 'January 1, 2012', 'January 1, 2013', and 'January 1, 2014'. These dates are the beginning for of each Fiscal Year in the data set. As far as filtering is concerned, everything is working perfectly. However, I am wondering if it would be possible to format the date values based on the parameter. So, if 'Fiscal Year' is selected the values in the filter would be: '2011', 2012', '2013', and '2014'. For quarters it would change to 'Q1 2011', 'Q2 2011'.. and so on.  Any suggestions on how I can get the formatting to appear the way I want? I have attached an example workbook.

  • Issue#1041509: Tableau - Date range / parameter

     In the above picture, I need to show the total apps which is 2832 for all the dates but a running total for the new accounts. Also I need to show it based on the dates mentioned.For example, if i mention 11th June i should get the apps as 2832 but the accounts should be sum of those dates. Thanks,Sarath

  • Issue#1130646: Tableau - changing the format of a Date parameter

    For a Date field,Whatever display format is selected in edit parameter dialog box, it doesn't reflect in the parameter control. Please tell me how can I change the format of date parameter so that i can get .I don't want to convert it into filter or something as I am using it to filter sheets coming from different sources which is not possible if it's a filter

  • Issue#20: Tableau - Aggregation issue

        Hello all, I just want to begin by saying how much this forum has saved my job! Thanks everyone! I am having an issue getting my values to aggregate properly. I have attached two pictures below to help explain:BEFOREAFTERThe problem is that when I remove a dimension, the values are not aggregating properly. Each Facility and Cost Center should have 1 App attached to it and taking away Summary Pay type should not aggregate those Apps. Once I take away Cost Center, then they should begin to aggregate. I can use MAX() but then it keeps the same value when I get rid of cost center and I would want that to be Summed. The end goal of this is to track Dollars/App By facility and able to drilldown to cost center, then summary pay type and another layer of fidelity that I may add in. Thanks!

  • Issue#22: Tableau - average by day of week for dates within parameter range

    i would like to calculate the average Revenue by day of week for the parameter range (Baseline End and Start): if ([Baseline End] >= [RevenueDate] AND [Baseline Start] <= [RevenueDate])and [DayOfWeek] = 'Monday'then { AVG([Revenue]) }ELSEnullEND i seem to be getting more days then just Monday...? ??? thank you.

  • Issue#38: Tableau - Iterative Printing / PDF Creation Using Filter or Parameter

    Not having this has made life miserable this week. We need to have the ability to iteratively print a dashboard or view based on stepping through values in a filter or parameter. This would resolve scenarios where you want to be able to easily print (or PDF) several copies of the same dashboard / view with different content. In my scenario, I have a dashboard that can be filtered by hospital. In order to create a printable PDF for our CEO, I have to create/maintain 5 versions of the same dashboard (one for each hospital). If I could iteratively print, I would just set the iteration on the facility field and only maintain 1 dashboard. P.S. Iterative subscriptions would also be a positive. You could even allow the remembered views to be used as the iteration field.

  • Issue#73: Tableau - Pass-through number format for calculated fields based on a parameter

    When using a parameter to dynamically select fields with multiple number formats, let the final display format be based on the underlying field number format, instead of forcing the number format to be set on the calculated field that does the CASE selection. For example:  Field A: Percentage  Field B: Currency  Field C: Integer Create a parameter called "Select field for axis:" that lists "Field A", "Field B", and "Field C" as options. Then create a calculated field with a case statement for each field, and put that on the chart axis. Currently, you have to set the number format on the calculated field, which is going to be right for one field, but wrong for the other two fields. Instead, let the calculated field number format be based on the underlying field being used, so if the user selects Field A, the axis and tooltip show percentages; Field B, currency; and Field C, whole numbers. This would really help for highly interactive dashboards making

  • Issue#86: Tableau - Additional date time number formats

    I calculate time variances in some of my KPI dashboards that result in negative time values (e.g. if a procedure starts early it will be a negative variance from the planned time). Extending the custom number formats to allow for things like this would be great: "h:mm:ss;(h:mm:ss)". I currently have to color encode the values to be able to tell the difference between positive and negative values. It would also be great if this format worked like it does in Excel: "[h]:mm:ss". The brackets allow the hours to extend beyond a base 24 hour period. Currently 25 hours renders as "1:00:00". With my proposed format it would render as "25:00:00". [A related feature request is to support an actual TIME data type, that idea is at] [Edited 20150810 to add the TIME data type reference - Jonathan Drummey]

  • Issue#556: Tableau - Multiple Data Source Filtering Using Different Dimension than Parameter's

    Hi all, I’ve got a dashboard that has numerous sheets on it from multiple data sources. I’ve used a parameter to allow me to filter across all the data sources at once. The problem is, the dimension that I’ve used for my parameter is a product code that people can’t use for searching. What they need to use is the product name, but this product name dimension is in only one of the data sources. So is there a way for the user to select a product name in a quick filter on the dashboard and have all the vizzes change, even though it's the product code parameter that's filtering all the sheets?  Thanks!

  • Issue#1265: iPhone 5c: Can someone explain this date & time issue one iOS 8.3?

    This device has a very strange date & time issue (maybe multiple issues). Auto time/date will not automatically detect the timezonewill not automatically adjust to the correct time Maintain time/date the time will count upwards as normal until the screen is locked for roughly 10 minutes (sleep)once the device resumes from sleep (unlock) it will display the time that was registered immediately prior to sleeping - and will continue to count upwards as normal from there Manually setting time/date when manually setting the date & time, the day/month scroll will sporadically change - for example: above the selector bar will show 9 May, below the bar will show 11 May but inside the bar will show 26 Oct (all just example dates).when scrolling through the dates, the day/month will magically meld into the incorrect sequence of day/monthoften the 'set date & time' will jump forward or backward by as much as 30 years or more (sometimes also resetting to Unix Epoch)often the scro

  • Issue#3583: Tableau - Unbroken line with 2 columns (no date, 1 column is a bar)

    Hi, I have been looking a few different post across the web without any success in sorting my problem. First of all we are using Fiscal Months (e.g. the beginning of a month or quarter could start on the 18th) for our reporting so converting our date in continuous date does not fit in this case. All our months / quarter are string mapped in our database. I am trying to build a bars and line chart with a quarter timeline (see image below).There is a dual axis. The line "calculation1" is broken across the chart and would like it to be continuous. The calculation 1 isIF [Indication]="%blabla" then [Data1] END Could anyone help me with that please? regards, Alex

  • Issue#6204: DAX issue with Date data type

    I am having an issue today with a DAX formula. The scenario is as follows. I have 2 Power BI desktop files which are formatted identically. I have them linked to separate Excel workbooks which are formatted identically. I am inserting a calculated column into both datasets under "Modeling" in Power BI with the following formula: Week_Crctd = if(weeknum('Line Calls'[Date])<=52,(weeknum('Line Calls'[Date])),1)In one PBI desktop file, I receive the expected result; a whole number between 1 and 52 which varies correctly according to the [Date] value. In the other file, I receive the following error: ï»¿ As I mentioned before, both Excel files are formatted with the exact same number formatting in these columns and both PBI desktop files are formatted with the same Data Type, Format, Data Category, and Default Summarization. What gives? Thanks guys and gals