For example, column F records whether the respondent consumed chocolate: In the subsequent columns, there are the survey questions and responses with a 1 denoting whether the respondent marked the question with a Yes. Every record represents a single survey respondent with key dimensions such as age, gender, state and background. This is what our data looked like initially, and you probably have seen many databases or Excel sheets with a similar structure. With Tableau, we know the data is the foundation for everything we do, so we’ll begin by diving into the data schema that will be powering our view. All data has been generated from Mockaroo. In this example, we’ll be looking at a mock research company’s survey of snack tendencies across the U.S. We’ll take you through the steps below: The Foundation: Data Instead, by pivoting our data source and using Tableau features such as set and parameter actions, we were able to build an expanding sidebar where users could select the data they want. We attempted a couple of alternative methods, including creating a duplicate of the data source with only the required measures, but we found most of these methods to be fairly clunky and unwieldy:Ībove: Traditional method of adding/removing columns through Measure Names However, this method can get messy quickly as the Filters selection will include every available measure in the data source, and in this instance, we had over 100 measures. Traditionally, the way to add and remove columns in the Tableau interface is through the Measure Names filter. We ended up creating something like this: The data source was complex, and the interface had to be able to accommodate a wide range of use cases. On a recent project, we were looking to build one of these tools that would allow end users to dynamically build their own tables for their unique needs. At InterWorks, we believe data shouldn’t be limited to only those who can write their own SQL queries everyone should be able to explore and ask questions about their data with flexible and intuitive tools.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |