1 of 1 people found this helpful
Can you post a workbook with a few 10s of rows with removal of confidential columns?
Trying to understand what is happening will be near impossible otherwise
...huh. So when I create a secondary extract with a limited amount of data it fixes the problem. But if I create a full secondary extract with no limitations it persists.
I'll try to figure out a way to get a sample data set and workbook. Thanks
Ooook, so I filtered my main extract to retain only non-null values for rebill_amount (note that when I search for these with SQL it doesn't find any rows) and now all my numbers are showing correctly.
Still have no idea what was causing this problem, but I guess it's fixed now.
Maybe some sort of a data conversion issue? What is the field type in SQL Server? How is the field described in Tableau?
It's an int(10) in our MySQL db.
Here's the Tableau description:
Role: Continuous Measure
Type: Database column
Remote column: [transaction_summary].[rebill_amount]
Remote type: Four-byte, signed integer
Default aggregation: Sum
FYI, I had to take an additional step to get it working when I published the data source to my Tableau Server. Just setting the one data source filter on the original extract wasn't working when I created a new workbook using the source pulled from the server. I added a non-nulls only data source filter for both rebill_amount and my calculated TF_RebillAmount fields, and when I published that and tried again on a new workbook it all worked fine.