Hi ad. thanks for sharing this. I want to know, Does tableau's vituarl connection manage access rights of users logged in to each dashboard? For example, in a revenue report by each branch, user A of branch 1 only views data of branch 1.
@DataVizCanvasКүн бұрын
Yes that’s correct. You can set security at branch level or at user level or combination of both. In order to do that you have to set policy at data source level.
@shaikabdulrasheed54564 күн бұрын
Thanks for sharing. In my case, i have both Measure Name & Measure value and trying to create Cal Fields but Funnel i could create but coloring based on each individual field, not happening. Any help will be much appreciated.
@hubsun6 күн бұрын
Thank you. Very nicely explained. Liked the video.
@DataVizCanvas3 күн бұрын
Thanks you for supporting my channel 🙂
@mahenderkodela70749 күн бұрын
How can we get totals for the measures on the top
@riyaz744210 күн бұрын
pls can you send link of creation of Sankey chart
@DataVizCanvas9 күн бұрын
Please use below link to create Sankey chart using extension kzbin.info/www/bejne/nIebgHicfsSerqMsi=Jo_-rjQMbvooQOks
@maryharris649915 күн бұрын
Where do I find the drop down arrows?
@jaydeep962215 күн бұрын
Can we type filter value manually because minimum and maximum values are not visible.
@DataVizCanvas15 күн бұрын
Type in filter feature is only availabe for dimensions. Its not available for measure values. You can change measure values using slider as of now. May be in future tableau will release that functionality.
@rajeswariarumilli795715 күн бұрын
How do I add labels? Label is greyed out
@Ossy23016 күн бұрын
Thank you for the tutorial. Can you create for tree diagram too?
@Ossy23020 күн бұрын
Thank you for the brief and well explained tutorial. Please can you create videos for other viz extentions especially the tree diagram?
@DataVizCanvas9 күн бұрын
Great suggestion! I will try.
@supreetbhatia463321 күн бұрын
Great tutorial. Thanks for sharing.
@DataVizCanvas21 күн бұрын
You are welcome. Glad you liked it.
@MN-gi4xy21 күн бұрын
Is this vis extension created and managed by you?
@DataVizCanvas21 күн бұрын
@@MN-gi4xy no , it’s crated by tableau. There are more extensions that are created by third party companies and some by tableau community members in collaboration with tableau.
@NehaKumari-hg4cc28 күн бұрын
I have a doubt Suppose I have created a field where I have to find the current quarter sales that is 2024 Q2 and previous quarter sales 2023 Q2 and then find the % change. For current quarter sales, I have hardcoded the year as 2024 but for quarter I have created a parameter that is select quarter and put that parameter in calculation to make it dynamic . And I did the same for 2023. Then I have created another calculated field to find the % change between them. Now I want to add indicators for downward and upward sign according to % change for Q1, Q2 and so on which is controlled by me. How can I add kpi red/ green indicators to them
@DataVizCanvas22 күн бұрын
Thats a great question. You could create a dynamic calculated field that gives the percentage difference between select quarter and selected quarter -1 based on your parameter selection. Please try that and let me know in case of any issues.
@ravtepdav29 күн бұрын
Great video, thanks a lot, I am currently cooking my personal web site and just found your video, I have a question, do you know which one of the two method is the best to embed a tableau dashboard?
@gitimayabal290329 күн бұрын
Very useful & clearly explain, thank you so much
@DataVizCanvas22 күн бұрын
You are welcome. Glad it was helpful!
@abdulwaritholawepo342429 күн бұрын
Legend
@DataVizCanvas22 күн бұрын
Thanks.
@user-kh7vr5cy9iАй бұрын
@DataVizCanvas additionally here how can I show data displaying only for latest 5 quarters. Because when I am trying to filter out the complete dataset is changing because of order of filter operations
@Deeprfc12346Ай бұрын
Thanks You Sir
@DataVizCanvasАй бұрын
You are welcome 🙏
@manamisahaАй бұрын
Can we write custom sql in virtual connection. Once virtual connection is created and we access it from desktop , I dont see any place to write custom sql
@DataVizCanvasАй бұрын
Unfortunately there is no option to write custom SQL with data source connecting to virtual connections. You might need to create a seperate object in virtual connection or create a view in database.
@neeleshapatilАй бұрын
Thank you ! For the first method using the shapes feature, if the data currently shows only positive year-over-year trends, how can we dynamically adjust those shapes in the event of potential negative growth in future data refreshes? I am working with a single KPI on the dashboard.
@fitaasrikaromah32Ай бұрын
Hi Sir, in the video u sow how to use virtual connection based on full name coz ur sample show one manager handle one region, how about if I want to use based on group name coz in my case one manager not only handle one region but more (it is mean that one user can be in more one metrics group). So let say Joni is manager in Region 1 & 2. So it means that Joni can see data from region 1 & 2.
@DataVizCanvasАй бұрын
That’s a great question. Yes if you set up row level security based on user name then that user can see all the data linked to it. In your example you can create local user group based and use that in the policy. That way you can manage users in policy by just adding them in the local group. Please try that and let me know in case of any issues.
@akhilssc74052 ай бұрын
What of we want to show in day level which changes dynamically and see proper date values? And also the region values are in different columns each for central, west etc?? Is it possible then?
@deeswift-z1h2 ай бұрын
Hi @datavizcanvas I have a dataset where I want to display the count of approved quotes over time while I showed it. It's showing the 0,1,2 for each date . That's correct while I need to see some change in height or length of the bars over there.
@sparken2 ай бұрын
Is there a way to do this when using a custom sql query as the data source? I can't union sql queries so this becomes impossible
@DivyaPatkar-z9h2 ай бұрын
Please slove this one question Who are 25th, 50th and 100th customers from top with respect to sum of sales in 2021?
@madhuripulimati1602 ай бұрын
Good work, thank you for the video
@DataVizCanvas2 ай бұрын
You are welcome. Glad you find it useful. 🙂
@chandanasrinivas57722 ай бұрын
Hi Gurpreet, thanks for sharing this. It was really helpful. I have a follow up question: Let' say I have a 1. Actual sales data (how much sales did a seller achieve) 2. Sales Target data (how much sales was the seller targeting to achieve) 3. Seller attributes (seller name, region etc.). With these data sets I need to combine seller name, seller target sales and seller actual sales and ensure that seller can only see their own data. How can I do achieve this tableau virtual connection on Tableau Server Version: 2024.2.0? I'm basically trying to understand how can I join two tables (Actual sales data, Sales Target data) and apply rls (using Seller attributes data) simultaneously. Thanks again!
@DataVizCanvas2 ай бұрын
Thats a great question. Once you have applied row level security on the primary fact table and then join it with secondary table, it will only retrieve related rows from secondary table. Example: Table one is sales with row level security applied on Region (Central) Table two is returned orders and is joined with Table one on Order ID field.. Once the join is created in the workbook then it will only show all the sales made in Central region and corresponding returned items. Hope that helps.. Please feel free to reach out if you need more info.
@chandanasrinivas57722 ай бұрын
Hi Gurpreet, thanks for sharing this. It was really helpful. I have a follow up question: Let' say I have a 1. Actual sales data (how much sales did a seller achieve) 2. Sales Target data (how much sales was the seller targeting to achieve) 3. Seller attributes (seller name, region etc.). With these data sets I need to combine seller name, seller target sales and seller actual sales and ensure that seller can only see their own data. How can I do achieve this tableau virtual connection on Tableau Server Version: 2024.2.0? I'm basically trying to understand how can I join two tables (Actual sales data, Sales Target data) and apply rls (using Seller attributes data) simultaneously. Thanks again!
@DataVizCanvas2 ай бұрын
Thats a great question. Once you have applied row level security on the primary fact table and then join it with secondary table, it will only retrieve related rows from secondary table. Example: Table one is sales with row level security applied on Region (Central) Table two is returned orders and is joined with Table one on Order ID field.. Once the join is created in the workbook then it will only show all the sales made in Central region and corresponding returned items. Hope that helps.. Please feel free to reach out if you need more info.
@fatimagonzalez-novo97532 ай бұрын
I followed the same approach but my hierarchical tree needs to connect nodes in level 3 with nodes in level 1 for example, without any direct links to a node in level 2. However, when doing this in tableau, its causing some issues and placing the level 3 node in level 2. How can I fix this?
@DataVizCanvas2 ай бұрын
Seems like an issue with the start and end node.. Could you please share the link of the dashboard and i can have a look.
@fatimagonzalez-novo97532 ай бұрын
@@DataVizCanvas Thank you! My specific data would be the following, I just centered it around zero per level. Maybe I am doing something wrong? docs.google.com/spreadsheets/d/1L9ocAdHvSaB3UFFTAzyY8hHzSzc3-Uu_/edit?usp=sharing&ouid=110348840310824771709&rtpof=true&sd=true
@fatimagonzalez-novo97532 ай бұрын
@@DataVizCanvas Many thanks for the help! It is not allowing me to comment a link, how should I send it to you?
@hgoose952 ай бұрын
Can you share how it would be possible to sort the categories not by Rank (of sales) but instead a manual sort - ie I can choose if furniture is at the top regardless of sales? Thanks for your help
@DataVizCanvas2 ай бұрын
Thats a great question. You could use the custom sort on the dimension value rather than sales. Please try and let me know incase you need more info.. Cheers!
@ritwiksingh49372 ай бұрын
is it possible to remove lines when we hover over any data points?
@DataVizCanvas2 ай бұрын
No , we cant . Its basically selecting that data point and showing the details in the hover over.
@fatimagonzalez-novo97532 ай бұрын
really nice tutorial. Do you happen to have the script on how to set up the start_node_id and the end_node_id?
@DataVizCanvas2 ай бұрын
No, I dont have the script for this scenario. I generated the data manually for this tutorial. You can download the data from my tableau public profile
@michaelwijnhard33563 ай бұрын
Thank You very much !!!
@DataVizCanvas2 ай бұрын
You are welcome! Glad it was helpful !
@Jitenderkumar-vv3ep3 ай бұрын
this is good thanks a lot, however, if i just want to show the null value months only and other side where the sales were done, how that can be done ?
@DataVizCanvas2 ай бұрын
Try using Tableau relationship data model. That will help you to cover such scenarios. Please check my tutorial on Relationships kzbin.info/www/bejne/e52naZ2Yo7Gdl9k
@KanaalvanL0tte100-qd4qo3 ай бұрын
Hi there! i love the video and we are using it in our company for a different use case where it is super valuable to make business decisions! Could you however explain why in the 'Sales' function you use WINDOW_SUM, this i dont understand
@aishwaryahatti28133 ай бұрын
This was very helpful! Thank you!
@DataVizCanvas3 ай бұрын
You are welcome. Please stay tuned for more such videos.
@vinaymaddi48013 ай бұрын
I dont see option to create virtual connection in my companys cloud server
@DataVizCanvas3 ай бұрын
That's a great question. Virtual connections are only available if you have Data management Add on. Please check with your tableau Admin in your company if they can get Data management add on.
@vinaymaddi48013 ай бұрын
@@DataVizCanvas okay.Thanks for the reply.
@BinduVattikoti3 ай бұрын
it was so helpful thanks for making video and please make more videos on scenario based questions
@DataVizCanvas3 ай бұрын
Thanks for your feedback. I will try my best. Please feel free to share if you any scenario that you would like more information on?
@228323393 ай бұрын
You saved me. Thank You!!!
@DataVizCanvas3 ай бұрын
Glad I could help! You are welcome :-)
@sravanipatnaik46543 ай бұрын
Can we get the entire data into power point?
@DataVizCanvas3 ай бұрын
Not that I am aware of.
@SauravKumar-c4x2t3 ай бұрын
Really like it
@DataVizCanvas3 ай бұрын
Thanks for your feedback and supporting my channel.
@ayodele20133 ай бұрын
Tableau is stressful. All these steps just to see a funnel😢
@DataVizCanvas3 ай бұрын
Thanks for your feedback. I can understand your concern. Hopefully in the coming release tableau will come up with easy steps.
@wesleyplaysguitar4 ай бұрын
Why are the sales numbers halved? It doesnt reconcile to the data.
@DataVizCanvas3 ай бұрын
Seems like data densification is not implemented correctly. Please check the steps again
@px94184 ай бұрын
hi, if i want to do dynamic sorting by measure like the way with parameter, but only within each category of a dimension, is it possible?
@DataVizCanvas3 ай бұрын
Yes, you can by adding additional calculations. Please give a go and let me know if you need more info.
@vsagar4b384 ай бұрын
Thanks , helped for current value - default value in Parameter
@DataVizCanvas3 ай бұрын
Glad it helped! Please stay tuned for more such videos.
@gajasankarraja64144 ай бұрын
You can say step by step like why we need to do those things and what are the trying to implement you just simply saying and I don't understand what are you trying to say
@DataVizCanvas3 ай бұрын
Thanks for your feedback. Will see what i can do in future tutorial to make things more clear so my audience can understand it better. In the meanwhile if you have any questions, please feel free to reach out. :-)
@NareskanthM5 ай бұрын
Great brother ! thanks a lot !
@DataVizCanvas5 ай бұрын
You are welcome. 🙏
@mohamedshlibik61905 ай бұрын
thanks, this is very helpful
@DataVizCanvas5 ай бұрын
You are welcome. Glad you liked it 🙏
@kuldeepkevat-u3u5 ай бұрын
are bhaiya debate me Kisi knowledgeable person ko bulao. aap log bhi na kisis ko bitha dete ho
@DataVizCanvas5 ай бұрын
Thanks for your feedback
@huntersprigings85335 ай бұрын
Thank you very helpful however, I get a error for the intersect function: Cannot mix aggregate and non-aggregate arguments with this function
@DataVizCanvas4 ай бұрын
This error message comes when you are aggregate value is mixed with non aggregate value. Try using Attr() function for non aggregate value.