Skip to main content

I work on a large Data Set : 6 Billion plus rows using Live Connections.

 

Created a worksheet using Aggregate Binning. I understand this can be done using only Fixed. Please let me know if I am wrong. (Include does not create a dimesnsion that can be used as a Bin)

 

All filters (about 10 of them) should be applicable to this Viz. So I have converted all the filters to Context Filters.

The time it takes now is phenomenon. 12 minutes.

 

The question

 

From a performance perspective which is better

 

Using 10 Context Filters

 

OR

 

Using {Fixed Dim 1, Dim 2 ... Dim N

and No Context Filters.

 

(I am assuming both would give the same results but I have yet to verify it)

 

OR

 

Is there a hybrid way (Some Context and Some in the Fixed Formula)

 

I guess there is no right or wrong but any indication on how to measure performance will also help.

 

Some Info - Not all the filters would reduce the size of the data to 1/10th. This is a general guideline given by Tableau while deciding to use Context Filters.}

Patrick Van Der Hyde

답변 2개
0/9000