#LOD

Подписаться 10 тыс.

Просмотров 18 тыс.

50% 1

Hello #datafam ,
In this video I have tried to simplify what is LOD and how can we create #LOD or #Levelofdetailexpression in #tableau .
I have discussed simple to complex questions asked in the #interviewquestions, #tableauinterview ,#tableaudeveloper
#lodintableau,
#tableaulod,
#talbeauinterviewquestions,
#lodtableau
1. How to find New and Existing Customers
2. Repeating Customers
3. Averages
4. Min and Max etc.,
help.tableau.com/current/pro/...
Do watch the video the completely and don't forget to like share and subscribe.

Наука

Опубликовано:

11 окт 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 72

@user-lg3ls7dj9t Месяц назад

Thank you for detail explaination of Level of Detail Expressions

@TechiRahul Месяц назад

Welcome 🙂 welcome 🤗

@ritikabali6466 11 месяцев назад

I must have watched 10 videos on LOD on youtube and everyone taught about what is LOD? no one taught how and where to use them. THIS IS THE BEST VIDEO ON LOD. will definitely save it for future reference. Thanks sir for this video. God Bless.

@user-cv1ji3xt2b 5 месяцев назад

Thank you for making this LOD simple for me.....THHHHAAANNKKSSS

@kirankalliguddi3617 Год назад

Understood fixed LOD and use cases, didn't understand much about Include,I will have to watch once again, thanks for taking your time to prepare these things for us!!!!

@jyotikafaldu5495 Год назад

I saw many video on filter bt first time I get throughly knowledge of filter...thank u so much sir

@TechiRahul Год назад

Glad to know Jyotika 🤝

@mershawubie1053 Год назад

I have seen a lot of videos regarding with LOD, but I found this interesting and clear. Thank you for sharing!!

@TechiRahul Год назад

Thankyou Mersha 🤝

@anamta_sayyed Год назад

very very well explained. Thank you so much for sharing.

@TechiRahul Год назад

🤝

@prudhvi5211 Год назад

Nice tips and v.v.well explained, thank you

@TechiRahul Год назад

Thanks Prudhvi

@vikassingh-hl6kh 6 месяцев назад

Absolute Fantastic Thank you Man.. You deserve an big applause

@joe9985902009 10 месяцев назад

Thank you so much it is very clear and understood much better in your videos and I didn't know of the fourth LOD thanks for that as well!!

@giridharankasturi3748 Год назад

just knew lod can be created by created in such ways.thnaks for the info

@TechiRahul Год назад

I am glad you found dem helpful. Don't forget to subscribe 😀

@ravitejabestagalam8148 Год назад

just got to know new things after watching this video...Thanks bro😀

@TechiRahul Год назад

Thanks Bro 😀😀 Hope you will remember ur 3 frnds 😛

@suumit2008 Год назад

Just came to know about quick LOD by this video :)... an excellent video Bro ...keep it up

@TechiRahul Год назад

Tksm Bro 🤝

@nagendrapedipina7832 Год назад

One of the best video on LOD's Boss, Keep uploading...

@TechiRahul Год назад

Tks Brother 🤝🤝🤝

@hpujari 10 месяцев назад

Thanks for this video❤

@tableaututorialstips71 Год назад

Mind blowing ,subscribed ,shared and liked :) ,Thanks for sharing pls upload more videos on when to use joins and how to choose which join is we need to use

@TechiRahul Год назад

Thanks

@sumitchaudhari5815 4 месяца назад

Video is very helpful.. I want to see repeat customer on YTD level- Month wise(who have place order in different month in YTD starting from Apr and 2. How can I see repeat customer in a month on week level. please help me with your advise on this. Thanks.

@sabyasachiojha3723 Год назад

Awsome video...

@TechiRahul Год назад

Thanks Ojha!

@mayankgarga6878 Год назад

Great Great Great

@TechiRahul Год назад

Thanks Mayank

@neerajgariya2887 Год назад

After finding the New Customer, just create a CF with Count function as count (New or Old) and then use grand total from analysis tab.

@himanshukhandelwal8850 Год назад

thanks from heart for this video

@TechiRahul Год назад

My pleasure don't forget to like share and subscribe Brother 🤝

@seema842 Год назад

thanks sir..jus nw got to knw various ways that v can use in lod.. also can u tel me about the difficulties faced in project?can u make a video on tat?please

@balapatil5503 Год назад

Hello ..By creating the first CF like {FIXED Customer Name: Min(order date)} and putting the field into the filter shelf, we can achieve the same result by filtering the most relevant year result...Is that ok

@sheruns8579 Год назад

I understand LODs but now I want to know when is the right time to use an LOD? And why?

@TechiRahul Год назад

Hi, You want to work independently without getting impacted with what is in view.

@tonyyadav1350 Год назад

Use index l, convert index to discreet to get count of new customer

@narendrajuturu7865 Год назад

hello sir can you please explain the FILTERS fully with use cases and also advanced charts. thank you

@TechiRahul Год назад

Sure I will upload video on this.

@sumitchaudhari5815 4 месяца назад

i did not understand in min sales for each month "{fixed datetrunc('month',order date): sum(sales)}" why datetrunc used here it will give us first date of months and because of it, it will take only first date of month sale rights or not? please explain

@ravitejabestagalam8148 Год назад

If we have dimensions from Excel file and measures from SQL server, can we use LOD's on such data and if yes how? Can you plz help with this?

@TechiRahul Год назад

Interesting Question Ravi. First thing is when you are bringing in from 2 data sources you should have atleast one column. N when you are trying to write LOD on top of that i think you need to get all of them from single datasource otherwise it might not work. I hope this helps you.

@bannochang 11 месяцев назад

{ FIXED [Customer Name]:MIN([Order Date])} , then Put CountD in the column - . Make it discrete , Put the calculated Field New customer or Old in the Text Shelf /Filter .

@bannochang 11 месяцев назад

Please share some video for combined axis and dual axis

@GauravKumar-sw4pk Год назад

Is this type of questions are asked in freshers interview.

@TechiRahul Год назад

Some of them could be asked. But concept wise you need to be aware how this can be achieved.

@zakirhussain4193 10 месяцев назад

Pls provide me the logic for the above question on urgent basis rahul bhai..

@Divya-gn5lh Год назад

Video on all date function

@TechiRahul Год назад

Sure Divya am noting it down. Wil post after filters topic 🤝🤝🤝 thanks for reaching out ☺️

@spyder2374 11 месяцев назад

Why we wrote '[Customer Name]' after "Include" ?

@TechiRahul 11 месяцев назад

To consider him

@zakirhussain4193 10 месяцев назад

Rahul bhai... month on month customer status New customer: done sales in current month not in previous month. Existing customers: done sales in current month & previous month also Lost customers : done sales in previous month but not in current month..

@TechiRahul 10 месяцев назад

Let me try this sounds interesting 😃

@zakirhussain4193 10 месяцев назад

@sumitchaudhari5815 4 месяца назад

does video on this created?

@jhansim379 11 месяцев назад

[Fixed[customer]:(min[order date])]

@charmingdew86 Год назад

11 new customers.

@TechiRahul Год назад

Wow kirak ek dum 👌👌👌👌👌

@hpujari 10 месяцев назад

What version is this

@charmingdew86 Год назад

{ FIXED [Customer Name]: MIN([Order Date]) }

@TechiRahul Год назад

Super Shafi 👌👌👌👌

@swapnalakhpati2182 Год назад

new customer unique count 11

@swapnalakhpati2182 Год назад

Customers who orderd for each year 800?

@mathavraja4249 Год назад

Customer purchased in every year you can simply wtite like {Fixed customer name : countd(year(ordereate)) }

@TechiRahul Год назад

Hi Mathav, Will we know that he purchased in every year? I think as per ur calculation it will only give total orderss he placed. Example if a customer has 4 orders in single year and no orders there after then ur calculation will return 4. But we r trying to find customers who placed order in every year like that

@mathavraja4249 Год назад

@@TechiRahul Bro... Now I've corrected the calculation... It will work now...

@TechiRahul Год назад

Yes I think it will work now 🙂🤝 good try year(order date) was important 😀

@nagendrapedipina7832 Год назад

{ FIXED [Customer Name]: MIN([Order Date]) }

@TechiRahul Год назад

Nice