I'm after the mechanism of how Tableau create aggregated extracts for a datasource where the aggregation can be done at source like SQL Server, Red shift & Google Big Query.
we are sourcing the data from an order table which has order_datetime , value_of_order and other fields.
we only want order_datetime aggregated at day level and sum of ( value_of_order )
If tableu is doing option 2 I will need to change the datasource to be a custom SQL that aggregates the data first. essentially put the sql I listed in 1.1
I'm not entirely sure I understand what you're asking. Can you please clarify the problem?