1 of 1 people found this helpful
Could you post some sample data in a packaged workbook? There are a variety of ways to get at this kind of calculation in Tableau, and the exact calculations are dependent on how the data is organized.
As far as binning measures, Tableau is only able to use its built-in bin functions on non-aggregated measures. You can effectively create bins based on aggregated measures by setting the aggregated measure to be discrete in the view (clicking on the pill, and setting it to be discrete, which changes the pill from green to blue). This causes Tableau to draw headers for the values of pill instead of axes. This won't get you an exact histogram, but you can play with the width of the bars to get pretty close.
FYI, Steve Wexler has written a great series of posts on working with survey data in Tableau, this one is a good place to start: http://www.datarevelations.com/using-tableau-to-visualize-survey-data-part-1.html
Thanks Jonathan I managed to figure it out in the end. The posts you provided on analysis of survey data was really helpful. Thanks again
Can you share your answer to this question?? How do I average the unique rows of a scored survey?? It is averaging every row.