Being at home unable to open the workbook. However I can understand what you're looking for. I've created a similar data like yours. I hope this match with your datasets. If so then here is the solution.
Lets assume this is the data.
You can create a calc field and drag this to filters shelf and select 1
Let me know If you've any query. Or share me your sample data set in excel format with your expected output.
Hi Mahfooj thanks for your help
But i dont think this will help here. attaching the data, you can have a look at it and it has 2 sheets and one is the expected result.also please note i dont want to filter the view either.
Most Common.xlsx 9.0 KB
i am not able to open that file, since i am using Version 9.0 . i am not having any updated version of tableau.can you send me the workbook as version 9.0 file?
1 of 1 people found this helpful
Workbook is saved in public version 9.3. Anyways I'm sending you the walk through. Just follow the screen shots.
First create two calc fields
Now drag ID, Animal in rows shelf and count on label. Drag "Most Common Animal" calc field in filters shelf and select 1.
In filters shelf also maintain this
Let me know If you've any query.
Hi Mahfooj, thanks very much for your effort.although it did solved my problem for the current data, i have some concern when it comes to my actual workbook. As it contains a tabular report with left most column as ID and i have some 4 or 5 most common value fields to fill along with some normally aggregated measure values so if i limit the data in the filter shelf to find the most common value , it might also be affecting my normally aggregated measure values
ID Most Common Value For Field A Most Common Value For Field B Most Common Value For Field C UniqueConcatenate field D UniqueConcatenate field E UniqueConcatenate field F Sum(G) Avg(H)
as you can see above, i want a table like this in which all other columns other than ID is aggregating values/Strings along ID.
please help, if you can tell me a way to find an alternative for unique concatenate function too
Note: fields A,B,C,D,E,F are dimensions and fields G,H are measures
If you can provide a sample set of data as you've mentioned then I can try that. And also mentioned what exactly you mean to say by unique concatenation. will you concatenate the columns from the result set? Kindly explain.
Important note: Once you get your answer of your original query then Kindly make a practice of creating a new thread for new query.
So that me or someone else from the community can help you at the same time. Once you marked your thread as correct then hardly anybody will see your new query in the old post. I hope you'll do that. Happy analyzing.