Great explanation of using Tableau Fixed LOD. Also, including SQL query examples as a way validate Tableau calculated field results is super useful too. This extra effort provides viewers with unique and valuable information on your channel. Excellent job and thank you for sharing your knowledge and skill with us, Ankit! It is appreciated and I'm a subscriber now.
I had this single question asked in my final practical viva for TABLEAU subject in university exam and I just watched this video 2 hrs before the exam, then the result came and i got 93 in practical, THANK YOU SIR
Thanks a lot Ankit. please make a video on Include and Exclude LOd as well. 1 more thing : I think we can do this query in single select statement. Let me know if it is correct or not select category, sub-category, sum(sales) as sub-cat-sales, sum(sales) over(partition by category) as cat-sales from table group by 1,2
Hi sir, Very well explained. Thank you for making these videos and sharing them. Could you please make a video on include and exclude load too similar to fixed lod. Thank you
hello Ankit..i always have this concern that can't we do all the calculations in sql and we can dirctly import in power BI or tableau,sql file and use(i mean all the kpi's done in sql)
Hi Ankit, Hope this message finds you well!! I have one Question related to string- Suppose we have one string in which particular character occurs multiple times and we want to find all position of that character in whole string....how can we do this?can you please take this example in your Video ,that will be so helpful
@@ankitbansal6 Sir, Can u plz help me in this. Select material, Sum ({fixed [product],[product area]: Sum( {Fixed [product],[working days],[shiftid]:avg(profit)})}) ) I am trying but not able to achieve this
Great explanation of using Tableau Fixed LOD. Also, including SQL query examples as a way validate Tableau calculated field results is super useful too. This extra effort provides viewers with unique and valuable information on your channel. Excellent job and thank you for sharing your knowledge and skill with us, Ankit! It is appreciated and I'm a subscriber now.
Glad it was helpful! 🙂
I had this single question asked in my final practical viva for TABLEAU subject in university exam and I just watched this video 2 hrs before the exam, then the result came and i got 93 in practical, THANK YOU SIR
Brilliant 😊
Definitely one of the better videos on UA-cam. Well done. Thanks!
Glad you liked it!
Thanks a lot Ankit.
please make a video on Include and Exclude LOd as well.
1 more thing :
I think we can do this query in single select statement. Let me know if it is correct or not
select category,
sub-category,
sum(sales) as sub-cat-sales,
sum(sales) over(partition by category) as cat-sales
from table
group by 1,2
Yes you are right . You just need to use double sum when using partition by
very well explained the reason for fixed LOD in tableau. It would be great if you could make video on include and exclude LOD with SQL.
Thank you.
Sure
Wow great explanation
And a great idea to cover the LOD implementation in SQL as well
That definitely helped
Thankyou sir🙏
great explanation, also we can use table calculation in Tableau to get the % in more sort way.
Hi sir, Very well explained. Thank you for making these videos and sharing them.
Could you please make a video on include and exclude load too similar to fixed lod. Thank you
Sure I will
Ankit Sir,
I upload database (in csv) given above in mysql workbench but only 137 rows are uploaded. How I can upload whole database.
Hello! Ankit great explanation
Please make a video on include and exclude lod too...with side by side SQL comparison ❤️
Sure
hello Ankit..i always have this concern that can't we do all the calculations in sql and we can dirctly import in power BI or tableau,sql file and use(i mean all the kpi's done in sql)
Hi Ankit, Hope this message finds you well!! I have one Question related to string- Suppose we have one string in which particular character occurs multiple times and we want to find all position of that character in whole string....how can we do this?can you please take this example in your Video ,that will be so helpful
Ankit sir kindly made a video for join the topic in depth
Hi @Ankit Clearly explained with example, please make a video on include and exclude LOD's as well
Sure
Hi Ankit,thanks for the awesome content.
I have just one request ,can u share how can we achieve this if we have multiple lod expression
You can create multiple columns using different partition by
@@ankitbansal6
Sir,
Can u plz help me in this.
Select material,
Sum
({fixed [product],[product area]:
Sum(
{Fixed [product],[working days],[shiftid]:avg(profit)})})
)
I am trying but not able to achieve this
Hi Ankit,
Very clearly explained 👌
Please make video on Include and Exclude as well
Sure
Sir pls upload more content on tableau like sql
hats off!
Prepare a course on Tableau, Namate Tableau !!!
Definitely 💯
Ankit sir pls convert sql course in hindi language for better understand sql who not comfort in english
Pls reply krna
If possible
Next SQL course will be in Hindi
Thank your Sir
Welcome