Tableau in Telugu - Level of detail (LOD) expressions explained with examples — Transcript
Full transcript
- 0:00a
- 0:18different level of granularity
- 0:20calculations performed
- 0:23calculations
- 0:24first of all
- 0:26foreign
- 0:31[Music]
- 0:37level of data
- 0:40more granular of data
- 0:48so it's not a data adjustment is
- 0:55calculations
- 1:05from Tableau 9 9.0 version okay for
- 1:10example if
- 1:11academic sum of sales soon
- 1:27calculation output
- 1:30furniture
- 1:32and the only furniture
- 1:35foreign foreign
- 2:10calculations level of detail expression
- 2:14for example each scenario on a Monaco
- 2:18furniture
- 2:27so simplicity so
- 2:32cases
- 2:40e value divided by Furniture total value
- 2:47Furniture total value
- 2:50is
- 3:00so
- 3:04sales
- 3:10category
- 3:17okay
- 3:20basically I'm gonna go three types of L
- 3:23word expressions
- 3:26exclude
- 3:28so e calculation one of fixed degree
- 3:30fixed reviews
- 3:37any type of L Body
- 3:41type of elbow dimensions
- 3:47so category
- 3:51aggregate function summer average
- 3:55measure sales
- 3:57close the floor brackets okay
- 4:00click ok
- 4:03so Equity calculation
- 4:18record total value
- 4:23foreign
- 4:30okay
- 4:34sum of sales
- 4:43amount of sales divided by
- 4:46sales at category
- 4:50cannot mix Aggregate and non-aggregate
- 4:53arguments
- 4:57foreign
- 5:04click ok
- 5:14numbers options then percentage
- 5:16conversion format
- 5:20percentage
- 5:23okay
- 5:27so e percentage adjustive overall value
- 5:2915.5 percent out of Furniture so
- 5:34Furniture category
- 5:36chase the 44.3 percent
- 5:40in the fixed reality calculation
- 5:44next to include L Body
- 5:47include already you producer summary
- 5:53dimensions
- 6:08so for example
- 6:11sorry
- 6:14[Music]
- 6:33the average sale value 2019.
- 6:37average value
- 6:40out of
- 6:43a region generally
- 6:46okay
- 6:51include
- 6:54reasons
- 6:57calculation performance
- 7:00reasons
- 7:10[Music]
- 7:33thank you
- 7:36so then output then output or difference
- 7:38in the area of the strangers
- 7:46order date
- 7:48sum of sales
- 7:5948427 is the total sales value in 2019.
- 8:03okay the average at a calculator in the
- 8:06243 which is
- 8:12total number of Records
- 8:14unionized with them
- 8:17so just sum of 100 cool
- 8:21total number of Records
- 8:34[Music]
- 8:36so 994
- 8:42so your output allowance
- 8:45total sales
- 8:48divided by
- 8:50994
- 8:57sorry so number of Records
- 9:02any total number of Records so kind of
- 9:042019 1993
- 9:08divided by
- 9:111993 so 243
- 9:15[Music]
- 9:15.
- 9:16some total sales value divided by
- 9:20total number
- 9:22so 243 is
- 9:25foreign
- 9:58calculation some total sales
- 10:03you should remember here first sum JC
- 10:07dharmada
- 10:09mono aggregation average
- 10:12foreign
- 10:22[Music]
- 10:28wanna
- 10:29foreign
- 11:00divided by 4 decimal
- 11:03s
- 11:07which is
- 11:12next excluded body
- 11:17same similar again so fictional body
- 11:20application
- 11:21at any level of data
- 11:23calculations
- 11:31include a place Charlie
- 11:35Monaco Lane Fields calculations
- 11:57Okay so
- 12:03all the calculation deletion right click
- 12:07delete okay
- 12:09okay so to category sub category
- 12:12and a sales okay
- 12:15put excluded
- 12:18images
- 12:32say exclude
- 12:36sub category
- 12:39some more since
- 12:41so did not put a Emerson Monica
- 12:45next
- 12:48foreign
- 12:55okay
- 12:56so it's giving the furniture total sales
- 12:59value so moving tot office supply
- 13:02sales value
- 13:04for every record Okay so
- 13:11foreign
- 13:25[Music]
- 13:29fixed category
- 13:31okay the fixers
- 13:34render same outputation
- 13:44calculations
- 13:50foreign
- 14:17foreign
- 14:22foreign
- 14:47okay
- 14:52Monaco
- 14:55we got 10 dimensions
- 14:59category level
- 15:02s
- 15:19in
- 15:21excluded then you did Jesse
- 15:26exclude subcategory comma
- 15:31year of order date
- 15:34is
- 15:42same output actually
- 15:48dead parties
- 15:55sorry
- 16:03okay
- 16:04if you
- 16:06exclude a fixed Vector fixed name and
- 16:09I'm right click JC
- 16:12convert to Dimension option in the
- 16:14molecule then you convert this
- 16:18is
- 16:18[Music]
- 16:27to the right click Jesse it just say you
- 16:30could convert to dimension name optional
- 16:32dimensions
- 16:35[Music]
- 16:45is the main differences
- 16:53so these are the three types of L Body
- 16:56expressions in tableau
- 16:59next video
- 17:01real-time use cases
- 17:03to them
- 17:05okay
- 17:06some examples I will explain
- 17:17to any channel
About this transcript
This page contains the full transcript of Tableau in Telugu - Level of detail (LOD) expressions explained with examples by SQL Coder, generated from the public captions YouTube serves with the video. The transcript has 552 words across 186 segments, with the original timestamps preserved so you can click any line to jump to that moment in the embedded player.
What you can do with it
Use the transcript to take notes, quote the speaker, build a study guide, generate a summary with ChatGPT or Claude via the YouTube Summary tool, or export it as a timed subtitle file with YouTube to SRT. You can also re-open it in the transcriber to translate the transcript into 100+ languages.
Free YouTube transcript tool
YouTube2Text is a free YouTube transcript generator — no signup, no daily limit. Paste any YouTube link and get the full transcript instantly, with timestamps, click-to-jump, translation to 100+ languages, AI prompts for ChatGPT, Claude, and Gemini, and exports to TXT, SRT, VTT, or Markdown.