Hi, I am trying to get 100 columns but in newer versions the option row level is not there, and i have changed Table layout column value to 50 and tried following the steps and still i am not able to see the row level option in xml data to edit value to 100. Can please suggest how to resolve this.
Hi. Is this still available in latest tableau ? I am unable to found this row-levels in my file. Can you please guide ? Only borders etc settings are there
Hi Asad, in the latest version number of columns have been increased to 50. You can check it in Analysis->Table Layout-> Advance. So till 50 columns you will not face any issue but beyond 50 you need to follow same procedure. In xml file it will be not visible until you change the default no. Change the default 50 to 49. Save the file and check in xml again, it will start showing there.
Twbx is a zip/ packaged file with data, images and twb file combined. Hence will show gibberish when u will try to open as XML. Correct way is to right click twbx and click unpackage option. It will unzip twbx into a folder having data and files and a twb file out of folder. Open this twb in notepad and edit as per video. You can later save it as twbx again.
@businessintelligencetools Sir could you please tell how to get date (let's say month, Quarter) repeatedly in every single row. like Quarter Q1 for all the rows in category Q1 then office supply, Q1 furniture, Q1office supply again. Basically instead Q1 one time and rest of the rows are blank. It should be Q1 written in every single row. Reference above video timing 5:39
I was asked this question in interview. We have limit of placing 16 dimensions in row or columns shelf can we extend that limit? I said no, then interviewer replied yes we can
@@businessintelligencetools4964 hi Sir, A very good day to you. To clarify my concern, I want to drag the filter box at the Top with dropdown : example "State, category, City" can you Please show me how to put that at the Top including the dropdown? I badly need that to my report. Please help. I can't able to attached the screenshot. :(
@@lunieamar6960 Best way is after creating sheet, drag and drop to dashboard. On dashboard, when you select sheet you get a drop option just below the cross button. In that menu there is filter option. On hovering to filter it will list all columns used to creat viz. Just click on req column and it will appear on sheet.
@@lunieamar6960 further you can use a vertical object with even distribution property and put all the filters there with drop-down option selected in filter.
Thank you for sharing. Very helpful, especially one of the replies (change the limit from 50 to 49 first then change the xml file)
excellent video .thank you for sharing!!
Glad it helped
Hi,
I am trying to get 100 columns but in newer versions the option row level is not there, and i have changed Table layout column value to 50 and tried following the steps and still i am not able to see the row level option in xml data to edit value to 100. Can please suggest how to resolve this.
this really helps
Glad to hear that.
Hi.
Is this still available in latest tableau ? I am unable to found this row-levels in my file. Can you please guide ? Only borders etc settings are there
Hi Asad, in the latest version number of columns have been increased to 50. You can check it in Analysis->Table Layout-> Advance.
So till 50 columns you will not face any issue but beyond 50 you need to follow same procedure.
In xml file it will be not visible until you change the default no. Change the default 50 to 49. Save the file and check in xml again, it will start showing there.
Why I'm not able to open twbx in xml format, If I'm trying to do so then it is some gibberish but not xml? I'm using 2021.1 version
Twbx is a zip/ packaged file with data, images and twb file combined. Hence will show gibberish when u will try to open as XML. Correct way is to right click twbx and click unpackage option. It will unzip twbx into a folder having data and files and a twb file out of folder. Open this twb in notepad and edit as per video. You can later save it as twbx again.
@@businessintelligencetools4964 Thanks, It worked!
@@rangareddyp42 glad it helped. Please support by subscribing to channel.
Very helpful
Glad it helped
thanks for sharing. really helpful
Glad it was helpful!
@businessintelligencetools Sir could you please tell how to get date (let's say month, Quarter) repeatedly in every single row. like Quarter Q1 for all the rows in category Q1 then office supply, Q1 furniture, Q1office supply again. Basically instead Q1 one time and rest of the rows are blank. It should be Q1 written in every single row. Reference above video timing 5:39
Please refer this video and let me know it works for you th-cam.com/video/ZHwdHYYiMFo/w-d-xo.html
I was asked this question in interview. We have limit of placing 16 dimensions in row or columns shelf can we extend that limit? I said no, then interviewer replied yes we can
Yes, so now you know how. 👍🏻
👍
hello Can you please help me how to remove the filters at the top?
Hi Amar, Can you please describe your problem. Which filter are you talking about?
@@businessintelligencetools4964 hi Sir, A very good day to you. To clarify my concern, I want to drag the filter box at the Top with dropdown : example "State, category, City" can you Please show me how to put that at the Top including the dropdown?
I badly need that to my report. Please help. I can't able to attached the screenshot. :(
@@lunieamar6960 Best way is after creating sheet, drag and drop to dashboard. On dashboard, when you select sheet you get a drop option just below the cross button. In that menu there is filter option. On hovering to filter it will list all columns used to creat viz. Just click on req column and it will appear on sheet.
@@lunieamar6960 further you can use a vertical object with even distribution property and put all the filters there with drop-down option selected in filter.
@@lunieamar6960 still if you want sample copy, share your mailing address.
Hi,
I am trying to get 100 columns but in newer versions the option row level is not there. Can please suggest how to resolve this
Hi, increase the table layout columns till 50 first as new version allows it and save it. Only then you can see this property.