Can you share the actual format with some sample of excel data?
1 of 1 people found this helpful
You've to change the format of your data first.
Try to get the below mentioned format. It will help you to get the correct output easily.
I've attached the workbook as well as the excel for your reference. Let me know If you've any query.
I am not entirely sure I understand what you are hoping to do.
There is a way to set up a parameter that will allow the user to choose one dimension to sort by. So you should be able to select one of your dates and it would then sort your other values either decending or ascending depending on what you would like. Does this address what you would like to do? If yes, I can explain how to do this.
If you just want to sort it for yourself you can select the little arrow on the pill and select sort. From here selecting Field and the variable you want to sort by might address your problem. This is something that is more just for you rather than the end-user though.
Let me know if this is helpful at all or else perhaps clarify what exactly you would like to do.
Thanks for the help. I understand that the data has to be modified to below mentioned format. But the data that i get everyday wont be of that format it will be on the format that i gave you. So if i were to visualize it then i will have to do some manual things everyday or i have to write a macro for this but if someone new comes in then they may not be able to maintain it. What i was wondering is that
1) Is there any way to do it like(programmatically or query or some other way) inside tableau to do what you just did like data mining so that it will be completely automated and the user can just place the excel in a folder and tableau will do the rest.
I cant thank you enough for your time to help me learn.
The data that i get will be unsorted and such that i cant use it directly to get my desired result. So i have to refine the data little bit to get my result.
What am trying to learn is that is there any(programmatic or Query based way) for excel inside tableau like data mining to refine the data inside tableau and use it to visualize. Dynamic way .
Please refer the pic in the question to get more idea.
Please let me know if you have any further doubts in the question
See while connecting your data tableau is giving such view
First of all you've to understand tableau is a visualization tool not any data formatting tool. I dont thing tableau has such capability to reformat your data in expected format which I've suggested earlier. You've to do at source (excel, db ect) level. Then connect to tableau. I would suggest try to educate the source to give you data in correct format so that you wont have to do any further data formatting. That will reduce your pain and you wont have to worry about someone If you left the job.
I hope you get my point.
Thanks for the help. Really appreciate it