Content in Tableau Community Forums

Creating a Dimension that is a list of all dates in Q2 2013

tableaucommunity@tableau.com — Wed, 10 Apr 2013 19:41:08 GMT

I'm making a target line to compare our actual numbers vs. projected. However, I would like the projected line to project out to the end of Q2 (June 30, 2013) and as of now it is only showing up to today. Is there a way to make a dimension that contains all date values for Q2 2013 that I could use in the calculated field calculation for the target line?

Placing target line on same graph as live-updating values

tableaucommunity@tableau.com — Wed, 10 Apr 2013 18:26:31 GMT

I have a measure (tshirts) that I would like to track on a line graph against a calculated field that represents the tshirt goal for Q2 2013. I have created the calculated field using this calculation:

68861 + MAX(DATEDIFF('day',#April 1, 2013#,[DateAson]))*12.51648

Adding 12.51 tshirts per day (from total of 68861 on April 1) will get us to our Q2 goal of 70,000 tshirts on June 30, 2013. DateAson is the date that feeds through from the DB for every record.

I would like these lines to show up on the same graph. I can't get it to work with a reference line.

Any ideas?

Using boolean dimensions in calculated fields??

tableaucommunity@tableau.com — Wed, 27 Mar 2013 17:52:16 GMT

I have three boolean dimensions (silver, gold, platinum) that determine how much a customer pays for my service. Each level costs an additional $1 on top of the $5 base charge. I would like to create a calculated field (billing amount) that checks to see whether each boolean dimension is true or false and then calculates the price depending on the result. [Subscriptions] is a measure.

I tried to do:

IF [Silver]= "TRUE" and [Gold]= "TRUE" and [Platinum]= "TRUE" THEN [Subscriptions]*8

ELSEIF [Silver]= "TRUE" and [Gold]= "TRUE" and [Platinum]= "FALSE" THEN [Subscriptions]*7

ELSEIF [Silver]= "TRUE" and [Gold]= "FALSE" and [Platinum]= "FALSE" THEN [Subscriptions]*6

ELSEIF [Silver]= "FALSE" and [Gold]= "FALSE" and [Platinum]= "FALSE" THEN [Subscriptions]*5

END

This does not work. How do I make the calculation test the boolean dimensions to see whether they return TRUE or FALSE?