It would be easier to help if you shared some (masked) data and the query so potential helpers can play with the data & query to see if they can make it work.
I know it takes time to prepare data & query so they can be safely shared. Therefore it might be easier for you to find a solution by reading previous threads about the same issue:
http://community.tableau.com/search?q=%22query+too+complex%22 (exact sentence, fewer results)
http://community.tableau.com/search?q=%22query+is+too+complex%22 (exact sentence, fewer results)
Can you show the query. Then only possible to made it simple.
Muthu Krishnan. M
i converted my 1st string to a date and called it svoc_date 3
LEFT([svoc_date], 4) // This covers the DD segment
+ "-" +
MID([svoc_date], 5,2) // The MMM segment
+ "-" +
RIGHT([svoc_date], 2) // The last two digits of YYYY
i now use svoc_date3 to create a new calculated field called campaign_analysis
if [svoc date 3] < [Extraction_dte] then 'Pre campaign analysis'
elseif [svoc date 3] > [Extraction_dte] then 'Post campaign analysis'
elseif [svoc date 3] = [Extraction_dte] then 'Extraction day campaign analysis'
so the calculations are all correct. as soon as i drag and drop the two into the row or column shelf i get the error
I agree your formulas already are simple and think you need to make the date conversion outside Tableau, so svoc_date is a date before it enters Tableau.
If your source is Excel, you can either make a formula in Excel or change the column itself to date.
If your data source is a CSV text file, then I would use schema.ini to ensure the field svoc_date is a date.
Ps. Here I shared a similar experience as yours: Re: The Calendar Workbook Collection
i have now just converted all my workbooks to extracts...this will be a problem next month as i need an automatic refresh on my worksheets as soon as the data source updates
What about a formula in Excel that converts the string/number to a date?
thanks, will quickly go and try that