forums

I want to graph some values against their percentile, to create a cumulative distribution plot. One way to do this is just to plot each value against some unique ID, but sort on the value. The drawback of that approach is that you don't get percentiles on the axis.

I tried to use the rawsql functions to call the SQL Server ntile() function, but this did not work, as Tableau wants to stick the ntile function down in the group by clause, which is not allowed.

I could (and probably will) write a custom SQL data source with the query that I want, but I was hoping for a little more 'elegant' solution, s would appreciate any ideas...