negative value if statement

tableaucommunity@tableau.com — Tue, 09 Oct 2012 12:52:02 GMT

Hi. Hopefully someone can help.

I have the following calculated field to create a table which categorises records.

If [Deadline Days] > 5 THEN "5+ Days to Deadline"

ELSEIF [Deadline Days] >4 Then "4 Days to Deadline"

ELSEIF [Deadline Days] >3 THEN "3 Days to Deadline"

ELSEIF [Deadline Days] >2 THEN "2 Days to Deadline"

ELSEIF [Deadline Days] >1 THEN "1 Days to Deadline"

ELSEIF [Deadline Days] >0 THEN "Less Than 1 Day to Deadline"

ELSEIF [Deadline Days] <0 Then "Deadline Passed Today"

ELSEIF [Deadline Days] <-1 Then "Deadline 1 Day Passed"

ELSEIF [Deadline Days] <-2 Then "Deadline 2 Days Passed"

END

The table that this creates is as follows

Less than 1 Day to Deadline	1 Day to Deadline	2 Days to Deadline	3 Days to Deadline	5+ Days to Deadline	Deadline passed today
8	9	25	33	16	350

The problem I have is that it is lumping all remaining items in to the Deadline passed today category and ignoring the last to ELSEIF statements to reflect that there is data where the deadline days are -1.25, 2.25 etc.

I am probably missing something obvious as to why it is ignoring the negative values ELSEIFs?

Any help would be appreciated.

Adding monthly targets

tableaucommunity@tableau.com — Fri, 04 May 2012 21:07:59 GMT

Hi. I have a table view of months with a count of the numbers of transactions completed each month. The source data is made up of the list of records and it is just a count of these records on a monthly basis.

I wanted to add in a monthly target to show on the table beside the actual number of transactions completed in that month. So for example I wanted to show for January the number of transactions (records) was 500 in January and then to show beside it that the target was 450. The targets are not in the source data so I thought that I might be able to do this by adding an excel datasource with a list of the months and the target next to each month. I did this but cant get it to appear on the table and linking month to month in both data sources does not seem to help.

Am I missing something here. Is there a better way to do this?

Thanks

Content in Tableau Community Forums

negative value if statement

Adding monthly targets