Here's a solution that presumes that the dates you have in the view go down to the day level. Create a calculated field like so:
IF DATETRUNC('day',[Order Date]) = DATETRUNC('day',NOW()) THEN [Sales] END
Then use that in the view, as in the attached view using the Superstore Sales sample data. The sales for the current month are displayed, while this calc shows only the sales for the current date.
Let me know if this works for you!
A calc something like:
if [date]=today() then [Sales] else 0 end
EDIT: Beaten by seconds - Jonathan's is more robust as it clears any times out as well.
First answer! First answer!
A bit more seriously, we could use a (I have no idea if this exists yet) next generation of forum software, where a user could mark themselves as working on a question/post and:
a) other users could see that the question was being worked on
b) instant messaging would be possible to ask questions, etc.
c) start up screensharing right there for collaborative problem solving and/or tutorials
In fact, I think I'll post that as an idea, check out http://community.tableau.com/ideas/1288.
Thanks Jonathan. Only problem is I get the error message"Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions. What can I do about that?
Calculations can be at the row level (like the one I created) or at an aggregate level (SUM(), COUNT(), all the table calculations, etc.), but not both at the same time, so that's why you're getting that error.
To get around this, Tableau provides a special aggregate function called ATTR() that returns the value of the field if there is only one value for that field in the current aggregation, otherwise it returns a special Null that is indicated by an asterisk *. So you can wrap non-aggregate fields in the calc in ATTR() and it should/might work.
If it doesn't, then we'd need to look more closely at your view. Posting a packaged workbook with some sample data would be useful to solve that issue.
Thanks Jonathan. I just broke the paid premium into its two components put the formula in for both and it worked great. I appreciate the help.
Also an idea so that url's pasted from the ideas section don't get doubled up in the forum...
(click your link...)