Fixed LOD Tableau vs SQL | Advanced Tableau Tutorial

[@uc7602]

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.

[@ankitbansal6]

Glad it was helpful! 🙂

[@stat_life]

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

[@ankitbansal6]

Brilliant 😊

[@adreamer9999]

Definitely one of the better videos on KZbin. Well done. Thanks!

[@ankitbansal6]

Glad you liked it!

[@madhvisingh9082]

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.

[@ankitbansal6]

Sure

[@djnepolian]

great explanation, also we can use table calculation in Tableau to get the % in more sort way.

[@shafi123]

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

[@ankitbansal6]

Yes you are right . You just need to use double sum when using partition by

[@dasoumya]

Hello! Ankit great explanation Please make a video on include and exclude lod too...with side by side SQL comparison ❤️

[@ankitbansal6]

Sure

[@avi8016]

Wow great explanation And a great idea to cover the LOD implementation in SQL as well That definitely helped Thankyou sir🙏

[@MeenakshiVKumbhar]

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

[@ankitbansal6]

Sure I will

[@komalpawar5124]

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

[@sabaparveen1099]

Ankit Sir, I upload database (in csv) given above in mysql workbench but only 137 rows are uploaded. How I can upload whole database.

[@leepthikamarichetty]

Hi @Ankit Clearly explained with example, please make a video on include and exclude LOD's as well

[@ankitbansal6]

Sure

[@SunilKumar-oh8pe]

Ankit sir kindly made a video for join the topic in depth

[@jececdept.9548]

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)

[@digitalishant124]

Sir pls upload more content on tableau like sql

[@HarshKukreja052]

Hi Ankit, Very clearly explained 👌 Please make video on Include and Exclude as well

[@ankitbansal6]

Sure

[@mdsultanahemad]

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

[@ankitbansal6]

You can create multiple columns using different partition by

[@mdsultanahemad]

@@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

[@sonysasane7689]

hats off!

[@himanshusingh-ny6co]

Prepare a course on Tableau, Namate Tableau !!!

[@ankitbansal6]

Definitely 💯

[@anshalsingh6007]

Ankit sir pls convert sql course in hindi language for better understand sql who not comfort in english

[@anshalsingh6007]

Pls reply krna

[@anshalsingh6007]

If possible

[@ankitbansal6]

Next SQL course will be in Hindi

[@suryap6518]

Thank your Sir

[@ankitbansal6]

Welcome