I'm getting an error on a calculated field:
A query error occurred. Domain information not available
The calculated field shows up as 0 (regardless of format changes). When I click "Describe" on the measure it shows the error above.
The field is a calculation on 2 other calculations in an extract (sourced via oracle). I have similar IF statements to create other calculations in the same extract and they work fine. Has anyone seen this error before on a calculated field?
Thanks,
Dave
Click Describe...
2015 $/Session
Role:
Continuous Measure
Type:
Calculated Field
Default aggregation:
Custom
Status:
Valid
Formula
if attr(year([Date])) = 2015 then
(sum([Gross $])/sum([Tracked Sessions])) else 0 end
A query error occurred. Domain information not available.
Running Tableau 8.2.2
Alex - i had those fields already in my source. They work fine.
I talked to Tableau Support and they told me to use a Min or Max function instead of ATTR. That worked!
if max(year([Date])) = 2015 then
(sum([Gross $])/sum([Tracked Sessions])) else 0 end
