Incremental Refresh is not enabled - why?

tableaucommunity@tableau.com — Wed, 22 Jan 2014 21:51:54 GMT

I am trying to schedule an incremental refresh of my data extract but the option to do an incremental refresh is dithered (grayed out). There are multiple columns in the data that should allow me to add an incremental refresh, since they are time stamps. I even took the precaution of using CAST to ensure that the column I want is of the correct data type (timestamp). I am using a custom SQL statement to get the data. Any ideas?

Thanks!

Ritu

Adding "N" for box plot

tableaucommunity@tableau.com — Tue, 09 Apr 2013 04:56:56 GMT

Hi --

I am having a bit of trouble figuring out how to do the following:

I have multiple rows per patient, with various dimensions and an outcome measure
It was easy enough to make a nice box and whisker plot (quartiles) for my outcome measure BUT
Because PATIENT_ID is on the Path and Level of Detail, when I ask Tableau to count how many patients are in a given category by using COUNTD(PATIENT_ID) all I get is a bunch of 1's. It won't let me aggregate.

I am getting frustrated because it's not that helpful seeing the box and whisker if you don't know what the N is. Our data are super-overdispersed so the size of the range isn't really the best indicator. I could go back and rewrite the SQL, pull quartiles in a hardcoded way, and then just plot a bunch of different reference lines, but for all of the combinations I am trying to look at, that would be less than ideal. Any ideas would be much appreciated!!

PS - Sorry I can't share the actual dataset since it's confidential patient data, but am happy to go into more detail re: columns, etc. if necessary!

Thanks!

Content in Tableau Community Forums

Incremental Refresh is not enabled - why?

Adding "N" for box plot