I have a dashboard that shows total sales for a day as well as revenue. I have a filter on that dashboard that allows me to go between days and see sales for a specific day (not every day of the year is in this filter). I want the filter to automatically go to today or the next closest day in the future when I publish it, while still allowing users to filter between days as they like. For example today is “7/11/24” let’s say there are no sales today but we have them for “7/14/24” and that’s the next day where sales show up. That should be the default date when users open the dashboard online. For those who are wondering and would like some clarification why we would look at future sales, I work in live events so this is essentially looking at sales for an upcoming event and tracking that.

I’ve been trying to convert a text field ($amount) into a numeric field. However, I keep running into an “Oracle database error 1722: ORA-01722: invalid number.” Does anyone know why this might be happening?

Is there a way to add calculated field to Detail marks of multiple worksheets in Tableau in bulk, or do I have to do this one at a time?

I have produced a calculate field which calculated the percentage of a salary scale based upon how many hours that scale worked during a specific activity, for example VR. Now for each activity I want to add up all the percentages of the salary scales. Although the percentage of each scale is correctly presented by the calculated field. The visualisation sums up the values for each day that that salary worked during that activity. That need to happen only ones.

I have a table that contains fields date, amount and Client_ID.

I have multiple worksheets that setting-up a switch method by Frequency (Yearly, Quarterly, Monthly, Weekly, Daily). When select the parameter frequency value in filter box, it does not show what i filtered.

Can you help me please with Tableau calculation fields?
I have measure “Leftovers” and dimension “Possibility of accommodation”.
I need to calculate another field – “Possible to accomodate leftovers” with such logic:
IF [Possibility of accommodation] <> “No”
THEN [Leftovers]
END
but this calculation makes values of “Possible to accomodate leftovers” greater than “Leftovers” although it should be less or equal.

I’m working on a calculation for “Second to Max Date” in order to compare the Max Date (as a most recent forecast) to the Second to Max Date (as the second to most recent forecast).

I’ve encountered an extremely perplexing problem in Tableau and hoping someone can help. I have a variable that contains 7 string values that correspond to numeric values in other columns in the data, of which I am only interested in four. Two of these values correspond to count values, and two correspond to rate values. I’ve created a parameter because I want users to be able to switch between these four measures on my dashboard. I’m using the following table calculation to build this visual:

I’ve encountered an extremely perplexing problem in Tableau and hoping someone can help. I have a variable that contains 7 string values that correspond to numeric values in other columns in the data, of which I am only interested in four. Two of these values correspond to count values, and two correspond to rate values. I’ve created a parameter because I want users to be able to switch between these four measures on my dashboard. I’m using the following table calculation to build this visual: