Skip to main content

Hello.

 

I have a data table that I'm pulling from Dremio via Tableau's "connect to a server" feature. When I have a live connection to the source in Tableau, the data matches with what I see in Dremio. However, when I create an extract one of the measures becomes extremely inflated and no longer matches with Dremio. This only happens to one measure. All other measures/dimensions are showing the correct data.

 

The measure giving me issues is a count of distinct invoice numbers by branch location, and by date. This distinct count is aggregated in the Dremio query, not in the dashboard. Within the dashboard, I am doing a simple calc: SUM(invoice_count).

 

The dremio data tables update once per day in the morning, so the time discrepancy between my extract and a live connection is not the culprit

 

I have tried deleting/recreating the extract multiple times but this didn't work.

 

Due to data privacy I am unable to share the twbx. Any guidance on potential causes for this issue is appreciated.

 

Thanks,

Maclain

1 个回答
0/9000