btProvider
btProvider
  • 421
  • 597 611
How to Define Context Variables in Talend?
Learn how to efficiently configure and manage context variables in Talend!
🚀 This SkillPill covers everything you need to know about defining context variables, whether as "Built-In" for individual Jobs or as reusable context groups in the Repository.
We'll dive into:
✔️ What contexts and context variables are
✔️ How to define and access them effectively
✔️ Real-world usage in an ETL process for transferring sales data from Excel to a database
✔️Make use of context variables for logging purposes
Unlock the power of context variables in Talend with a detailed, step-by-step guide from our colleague, 𝐑𝐚𝐫𝐞𝐬 𝐌𝐢𝐡𝐚𝐥𝐚𝐜𝐡𝐞, 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫 @𝐛𝐭𝐩𝐫𝐨𝐯𝐢𝐝𝐞𝐫𝟓𝟓𝟔𝟏!
Perfect for optimizing your workflows, improving consistency, and simplifying configuration across development, testing, and production environments. Watch now and elevate your Talend expertise! 💡
Learn more about btProvider: Website: btprovider.com/ Facebook:
/ btprovider LinkedIn: / business-technology-provider
#skillpill #talend #etl
Переглядів: 72

Відео

Cum să definești Variabilele de Context în Talend?
Переглядів 1521 день тому
Descoperă cum să configurezi și să gestionezi eficient variabilele de context în Talend! 🚀 Acest #SkillPill îți arată tot ce trebuie să știi despre definirea variabilelor de context, fie ca „Built-In” pentru Job-uri individuale, fie ca grupuri de context reutilizabile în Repository. Vei descoperi: ✔️ Ce sunt contexturile și variabilele de context ✔️ Cum să le definești și să le accesezi rapid ✔...
How to clean your data with Tableau Prep Builder?
Переглядів 130Місяць тому
In this #skillpill, you will learn how to use Tableau Prep Builder to clean, organize, and transform your data for analysis and visualization. Discover how to handle common data challenges like misspelled entries, duplicate rows, and inconsistent formats. Follow along with steps to connect to data, clean your dataset, and pivot columns, preparing your data for effective insights. Watch the full...
Cum să îți cureți datele cu Tableau Prep Builder?
Переглядів 12Місяць тому
Urmărește acest #Skillpill și învață cum să folosești Tableau Prep Builder pentru a curăța, organiza și transforma datele pentru analiză și vizualizări. Descoperă cum să gestionezi provocările comune ale datelor, precum intrările scrise greșit, rândurile duplicate și formatele inconsistente. Urmează pașii pentru a te conecta la date, a curăța setul de date și a pivota coloanele, pregătind datel...
How to schedule a Talend Studio process in Taland Cloud Management Console?
Переглядів 692 місяці тому
In this #SkillPill tutorial, you will go through the essential steps for creating and editing tasks within the Talend Cloud Management Console (TMC), allowing you to customize your workflows according to your needs. You’ll also discover how to set up execution plans for automated runs, making it easier to manage your data processes without manual intervention. Watch this #SkillPill video to str...
Cum să programezi un proces din Talend Studio să ruleze automat în TMC?
Переглядів 172 місяці тому
În acest #SkillPill, vei parcurge pașii pentru a crea și edita sarcini în cadrul Talend Cloud Management Console (TMC), permițându-ți să îți personalizezi fluxurile de lucru conform nevoilor tale. De asemenea, vei descoperi cum să configurezi planuri de execuție pentru rulări automate, facilitând gestionarea proceselor tale de date fără intervenție manuală. Urmărește acest #SkillPill pentru a-ț...
Cum să creezi un Simple Radar Chart în Tableau?
Переглядів 242 місяці тому
Învață cum să creezi cu ușurință un grafic radar în @Tableau urmând acest tutorial pas cu pas! În acest #Skillpill, îți arătăm cum să compari atributele mai multor instituții folosind instrumentele avansate de vizualizare și câmpurile calculate din Tableau. Graficele radar sunt perfecte pentru a vizualiza date complexe, permițându-ți să identifici rapid tendințele și să compari performanțele pe...
How to create a Simple Radar Chart in Tableau?
Переглядів 1592 місяці тому
Learn how to easily create a radar chart in @Tableau with our step-by-step tutorial! In this #Skillpill, we'll guide you through comparing multiple institutions' attributes using Tableau's powerful visualization tools and calculated fields. Radar charts are an excellent way to visualize multivariate data, making it easy to spot trends and compare performance across various categories. 𝗪𝗵𝗮𝘁 𝘆𝗼𝘂'...
Cum să folosești Metadata Repository în Talend?
Переглядів 433 місяці тому
🎬 Î𝐧 𝐚𝐜𝐞𝐬𝐭 𝐯𝐢𝐝𝐞𝐨 #𝐒𝐤𝐢𝐥𝐥𝐏𝐢𝐥𝐥, 𝐯𝐞𝐢 𝐝𝐞𝐬𝐜𝐨𝐩𝐞𝐫𝐢 𝐩𝐚𝐬 𝐜𝐮 𝐩𝐚𝐬 𝐜𝐮𝐦 𝐬ă 𝐠𝐞𝐬𝐭𝐢𝐨𝐧𝐞𝐳𝐢 𝐞𝐟𝐢𝐜𝐢𝐞𝐧𝐭 𝐝𝐚𝐭𝐞𝐥𝐞 𝐟𝐨𝐥𝐨𝐬𝐢𝐧𝐝 𝐦𝐞𝐭𝐚𝐝𝐚𝐭𝐚 î𝐧 𝐓𝐚𝐥𝐞𝐧𝐝! 🔍 🔧 𝐂𝐞 𝐯𝐞𝐢 𝐝𝐞𝐬𝐜𝐨𝐩𝐞𝐫𝐢: Crearea jobului și configurarea conexiunilor la baza de date 🛠️ Utilizarea metadata pentru tabele și fișiere CSV 📊 Adăugarea componentelor esențiale în Designer 🎨 💡 𝐀𝐜𝐞𝐬𝐭 #𝐒𝐤𝐢𝐥𝐥𝐏𝐢𝐥𝐥 𝐞𝐬𝐭𝐞 𝐢𝐝𝐞𝐚𝐥 𝐩𝐞𝐧𝐭𝐫𝐮 𝐜𝐞𝐢 𝐜𝐚𝐫𝐞 𝐝𝐨𝐫𝐞𝐬𝐜 𝐬ă-ș𝐢 𝐨𝐩𝐭𝐢𝐦𝐢𝐳𝐞𝐳𝐞 𝐟𝐥𝐮𝐱𝐮𝐫𝐢𝐥𝐞 𝐝𝐞 𝐥𝐮𝐜𝐫𝐮 ș𝐢 𝐬ă ...
How to use Repository Metadata with Talend?
Переглядів 1023 місяці тому
🎬 𝐈𝐧 𝐭𝐡𝐢𝐬 #𝐒𝐤𝐢𝐥𝐥𝐏𝐢𝐥𝐥 𝐯𝐢𝐝𝐞𝐨, 𝐲𝐨𝐮 𝐰𝐢𝐥𝐥 𝐝𝐢𝐬𝐜𝐨𝐯𝐞𝐫 𝐬𝐭𝐞𝐩-𝐛𝐲-𝐬𝐭𝐞𝐩 𝐡𝐨𝐰 𝐭𝐨 𝐦𝐚𝐧𝐚𝐠𝐞 𝐲𝐨𝐮𝐫 𝐝𝐚𝐭𝐚 𝐮𝐬𝐢𝐧𝐠 𝐦𝐞𝐭𝐚𝐝𝐚𝐭𝐚 𝐢𝐧 𝐓𝐚𝐥𝐞𝐧𝐝 𝐞𝐟𝐟𝐢𝐜𝐢𝐞𝐧𝐭𝐥𝐲! 🔍 🔧 𝐖𝐡𝐚𝐭 𝐲𝐨𝐮'𝐥𝐥 𝐝𝐢𝐬𝐜𝐨𝐯𝐞𝐫: Creating jobs and setting up database connections 🛠️ Using metadata for tables and CSV files 📊 Adding essential components in Designer 🎨 💡 𝐓𝐡𝐢𝐬 #𝐒𝐤𝐢𝐥𝐥𝐏𝐢𝐥𝐥 𝐢𝐬 𝐢𝐝𝐞𝐚𝐥 𝐟𝐨𝐫 𝐭𝐡𝐨𝐬𝐞 𝐰𝐡𝐨 𝐰𝐚𝐧𝐭 𝐭𝐨 𝐨𝐩𝐭𝐢𝐦𝐢𝐳𝐞 𝐭𝐡𝐞𝐢𝐫 𝐰𝐨𝐫𝐤𝐟𝐥𝐨𝐰𝐬 𝐚𝐧𝐝 𝐫𝐞𝐮𝐬𝐞 𝐦𝐞𝐭𝐚𝐝𝐚𝐭𝐚 𝐞𝐟𝐟𝐞𝐜𝐭𝐢𝐯𝐞𝐥𝐲. Whether...
Cum să creezi un Pace Chart în Tableau ?
Переглядів 583 місяці тому
📊 În acest #Skillpill, vei învăța pas cu pas cum să construiești un Pace Chart folosind Tableau Desktop - o soluție avansată pentru vizualizarea progresului față de obiective. Pace Charts sunt o alternativă eficientă la bullet graphs și sunt perfecte pentru comparații clare între KPIs din categorii variate, precum venituri, urmăritori pe rețele sociale și altele. 𝐂𝐞 𝐯𝐞𝐢 î𝐧𝐯ăț𝐚: 📈 Cum să creezi ...
How to create a Pace Chart in Tableau?
Переглядів 1183 місяці тому
📊 In this #Skillpill, you'll learn step-by-step how to create a Pace Chart using Tableau Desktop - an advanced solution for visualizing progress towards goals. Pace Charts are an effective alternative to bullet graphs and are perfect for making clear comparisons between KPIs from various categories, such as revenue, social media followers, and more. What you'll learn: 📈 How to create and connec...
Smart Talks with #data Super Heroes - Ciprian Nastasiu & Bianca Barcan
Переглядів 264 місяці тому
🌟 Learn about the real stories behind @btprovider5561 in this engaging video where Bianca Barcan and Ciprian Nastasiu share their personal journeys and the daily challenges that keep their work exciting. 🚀 Discover what it's like to work in a place where no two days are the same, and why btProvider is more than just a workplace. 💼 #teamsynergy #workplacevibes #careerjourney #officeculture #team...
Smart Talks with #data Super Heroes - Adrian Lisnic & Ana Brînaru & Natalia Drăgoescu
Переглядів 325 місяців тому
Are you curious how Ana Brînaru, Adrian Lisnic, and Natalia Drăgoescu's lives have evolved at @btprovider5561? 🤔✨ In this #SmartTalks video, you can discover how they have found joy, growth, and enthusiasm in their personal and professional lives. 🌟😊 Leave your thoughts in the comments! 💬 And remember, DATA IS OUR SUPERPOWER! 💪📊 #SmartTalks #btProvider #DataDriven #CompanyCulture #TeamGrowth #I...
Cum să efectuezi "database landing" cu Talend ?
Переглядів 315 місяців тому
Cum să efectuezi "database landing" cu Talend ?
How to perform database landing with Talend ?
Переглядів 675 місяців тому
How to perform database landing with Talend ?
Insights and innovations from "Pulse of the Future: Data & AI" | Featuring Ionut Polexe
Переглядів 125 місяців тому
Insights and innovations from "Pulse of the Future: Data & AI" | Featuring Ionut Polexe
Insights and innovations from "Pulse of the Future: Data & AI" | Featuring Bogdan Chiriac
Переглядів 135 місяців тому
Insights and innovations from "Pulse of the Future: Data & AI" | Featuring Bogdan Chiriac
How to create a difference bar chart?
Переглядів 1015 місяців тому
How to create a difference bar chart?
Cum să creezi un grafic cu bare de diferență?
Переглядів 455 місяців тому
Cum să creezi un grafic cu bare de diferență?
Pulse of the Future: Data & AI 2024
Переглядів 425 місяців тому
Pulse of the Future: Data & AI 2024
How to filter your Data with Talend ?
Переглядів 1786 місяців тому
How to filter your Data with Talend ?
Cum să filtrezi datele cu Talend?
Переглядів 206 місяців тому
Cum să filtrezi datele cu Talend?
Smart Talks with #data Super Heroes - Mara Cîșlariu & Ana-Maria Iancu
Переглядів 456 місяців тому
Smart Talks with #data Super Heroes - Mara Cîșlariu & Ana-Maria Iancu
Cum să realizezi o Regresie Liniară în Tableau?
Переглядів 527 місяців тому
Cum să realizezi o Regresie Liniară în Tableau?
How to perform Linear Regression in Tableau?
Переглядів 1,1 тис.7 місяців тому
How to perform Linear Regression in Tableau?
Smart Talks with #data Super Heroes - Alexandru Stăncescu & Maximilian Muntean
Переглядів 798 місяців тому
Smart Talks with #data Super Heroes - Alexandru Stăncescu & Maximilian Muntean
Cum să exporți grafice în PDF și PNG
Переглядів 369 місяців тому
Cum să exporți grafice în PDF și PNG
How to export Dashboards in PDF and PNG
Переглядів 2609 місяців тому
How to export Dashboards in PDF and PNG
Cum sa citesti date dintr-un Excel file cu #Talend?
Переглядів 3910 місяців тому
Cum sa citesti date dintr-un Excel file cu #Talend?

КОМЕНТАРІ

  • @veronicaflorea8289
    @veronicaflorea8289 25 днів тому

    Great job on that video!💯

  • @PiaKrista
    @PiaKrista Місяць тому

    very helpful - thank you!

  • @christian.saluzzo
    @christian.saluzzo Місяць тому

    Excellent, thanks for sharing it

  • @kevinnguyen4393
    @kevinnguyen4393 3 місяці тому

    I am receiving an error about the MAX([Standard Deviation]) that it cannot be further aggregated. Any tips?

  • @MihaiIlie-wv8sc
    @MihaiIlie-wv8sc 3 місяці тому

    Sigur cae bine sa exportam din cadrul Parchetului de apel dar cred ca timpu e prețios și timpu duce bună stare sau nenorocire insa la activități de investiti e bunăstare din fâșie dacă se respecta destinația bnilor

  • @PrarthanaThite
    @PrarthanaThite 5 місяців тому

    in Tableau , can we extract the paginated report in the PDF format ,like in Power BI?

    • @btprovider5561
      @btprovider5561 4 місяці тому

      We appreciate your interest in this #SkillPill! You can create a story for the paginated dashboard and then you can export the story as a PDF.

  • @PrarthanaThite
    @PrarthanaThite 5 місяців тому

    Hello, Can we extract the paginated report in pdf format like in Power BI?

    • @btprovider5561
      @btprovider5561 4 місяці тому

      We appreciate your interest in this #SkillPill! You can create a story for the paginated dashboard and then you can export the story as a PDF.

  • @umistry5115
    @umistry5115 6 місяців тому

    Brilliant...so easy to follow and a fantastic end product!

    • @btprovider5561
      @btprovider5561 4 місяці тому

      Thank you for sharing your feedback with us! 🙂 We greatly appreciate it. Here you can find more #SkillPills 👇 ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html&si=7xrZkYIqfoPMUffE

  • @ragragrec1
    @ragragrec1 7 місяців тому

    thx

    • @btprovider5561
      @btprovider5561 4 місяці тому

      Thank you! Here you can find more #SkillPills👇 ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html&si=7xrZkYIqfoPMUffE

  • @alexispivot6380
    @alexispivot6380 8 місяців тому

    Hello, Thanks for the video! I have a problem doing this : when I drag the Chart Type in filter, and I choose the value, tableau thinks a take all values and not just the one I chose

    • @btprovider5561
      @btprovider5561 4 місяці тому

      We appreciate your interest in this Skill Pill! When you bring the "Chart Type" on filter, please try the option of "Custom value list" to set the filter for each type of chart. This should solve the problem of hiding the charts based on the Parameter Action

  • @altonwelch2872
    @altonwelch2872 9 місяців тому

    😇 "promo sm"

  • @andracoisbored
    @andracoisbored 9 місяців тому

    thank you for this 🙂🙂 ciao

    • @btprovider5561
      @btprovider5561 4 місяці тому

      Thank you! 🙂 Here you can find more #SkillPills 👇 ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html&si=7xrZkYIqfoPMUffE

  • @esteban-alvino
    @esteban-alvino 9 місяців тому

    Interesting

    • @btprovider5561
      @btprovider5561 4 місяці тому

      Thank you!🙂 Here you can find more #SkillPills ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html&si=7xrZkYIqfoPMUffE

  • @subby788
    @subby788 9 місяців тому

    How do you set legend as continous colour gradient? All my values are discrete in my legend

    • @btprovider5561
      @btprovider5561 4 місяці тому

      We appreciate your interest in this Skill Pill! Please check that SUM(Sales), which is on Color, is green. If this is not the case, then right-click on it, and from the menu select "Continuous".

  • @ArjunSingh-cw8vn
    @ArjunSingh-cw8vn 10 місяців тому

    Thanks! Very helpful 😄

    • @btprovider5561
      @btprovider5561 4 місяці тому

      Thank you! 🙂 Here you can find more #SkillPills ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html&si=7xrZkYIqfoPMUffE

  • @antoniolupen6138
    @antoniolupen6138 10 місяців тому

    Absurdly complicated.

    • @btprovider5561
      @btprovider5561 4 місяці тому

      Thank you for sharing your feedback with us!🙂 We greatly appreciate it. We will take your feedback into consideration.

  • @EchoDiaz-u4t
    @EchoDiaz-u4t 10 місяців тому

    bravo!

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Thank you! Here you can find more #SkillPills: ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @markimusprime3
    @markimusprime3 11 місяців тому

    Thank you very much great video please keep making more

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your positive feedback! We're glad to hear that you found our video helpful. If you have any questions or if there's anything specific you'd like to see in future videos, feel free to let us know!

  • @Lucienne2610
    @Lucienne2610 11 місяців тому

    Do you offer tutoring for students on RStudio combined with Tableau?

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this Skill Pill! At this moment we don't have a tutorial for using R with Tableau, but you can follow the documentation provided by Tableau www.tableau.com/developer/tools/r-integration"

  • @julielittle7247
    @julielittle7247 Рік тому

    ✋ Promo*SM

  • @glennnutting1785
    @glennnutting1785 Рік тому

    Great video. Thanks a lot!

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Thank you! Here you can find more #SkillPills: ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @chanmad
    @chanmad Рік тому

    thanks for the excellent walkthrough!

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your positive feedback! We're glad to hear that you found our video helpful. If you have any questions or if there's anything specific you'd like to see in future videos, feel free to let us know!

  • @rigidsam
    @rigidsam Рік тому

    This was super helpful. Thank you for sharing.

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Thank you for your feedback! Here you can find more #SkillPills: ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @gabonicabas
    @gabonicabas Рік тому

    Awesome. Thanks for sharing.

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Thank you for your feedback! Here you can find more #SkillPills: ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @سعدحسينالعنزيحسين

    سعد حسين

  • @tomperks7477
    @tomperks7477 Рік тому

    Hi, thanks for the video! I have followed this step by step and I have an issue. Whenever I click on a location, the map zooms out to the same level - approximately setting the buffer at 250km, not the specified 10 meters. It does not matter if I set the buffer parameter at 5 or 1000 meters. The zoom is always the same and incorrect. What should I do to fix this?

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this #SkillPill! To provide the correct solution we will need more details and how the to calculated fields look like in your case. When you say that the map zooms out the level 250km, are you refering at the area around the point or the hole map?

  • @abhishek12865a
    @abhishek12865a Рік тому

    Thanks bt provider

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your positive feedback! We're glad to hear that you found our video helpful. If you have any questions or if there's anything specific you'd like to see in future videos, feel free to let us know!

  • @ZzZzZiggy
    @ZzZzZiggy Рік тому

    Foarte util! De-abia astept sa trec prin tot playlistul ❤

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Mulțumim pentru feedback-ul pozitiv! Ne bucurăm să aflăm că te-a ajutat videoclipul nostru! Dacă ai întrebări sau dacă există un topic pe care ai vrea să îl vezi în viitoarele #SkillPills, nu ezita să ne spui! Aici găsești Playlist-ul: ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @grigorescuremus6325
    @grigorescuremus6325 Рік тому

    Jenant... sa nu a aveti o aplicatie pentru Romania pe judete sau regiuni geografice....

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Multumim pentru interesul acordat acestui #SkillPill! Din păcate pentru România nu avem surse de date, publice, la nivelul acesta de detaliu astfel încât să putem genera o astfel de hartă.

  • @manwendersingh5749
    @manwendersingh5749 Рік тому

    I just found your channel it is very good. Great work 👏

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your positive feedback! We're glad to hear that you found our video helpful. If you have any questions or if there's anything specific, you'd like to see in future videos, feel free to let us know! Here you can find more #SkillPills: ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @matt1sauer
    @matt1sauer Рік тому

    I've tried to replicate this, but when I Hide Title, the worksheets still stay visible. Not sure what I'm doing wrong

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this #SkillPill! In this case is possible that the worksheets to have a fixed size. If you need to have a specific zise for each worksheet and the Tableau Server version is higher or equal, then 2022.3 then I will recomand to use Dynamic Zone Visibility to show/hide the workesheets. More details you can find here help.tableau.com/current/online/en-us/dynamic_zone_visibility.htm

  • @kapamagicman
    @kapamagicman Рік тому

    Awesome! Does this also change in the tooltip?

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this #SkillPill! For the change in the tooltip, you will need to edit it and replace the text "Dynamic Measure" with the parameter used to switch the measures.

  • @georgeopoku1674
    @georgeopoku1674 Рік тому

    Great demo. I have something similar where you click on Region on sample superstore data then I want to see that state belong to that particular region

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this #SkillPill! In the State\City Calculated Field you can replace State with Region and City with State and in this way you will be able to have the drilldown from Region to State

  • @franksellers7858
    @franksellers7858 Рік тому

    Great video but too advanced for beginners.

  • @shekinahglory2207
    @shekinahglory2207 Рік тому

    Hi, could you also do it the way around, so my sub category to be shown in percentage and totals in numbers. Thank you.

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this #SkillPill! To have the SubCategory in Percentage and the Subtotals as absolute numbers you will have the modify the Measure for Sales to have for Size = 1 the Percentage and for any other size to have the sum of sales. The most important thing is to adjust the Table Calculation so that the Total to be calculated at Subcategory and the Size for Category

  • @firstname4337
    @firstname4337 Рік тому

    I've been looking for this -- THANK YOU

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Thank you! Here you can find more #SkillPills: ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @rajeshtukdeo
    @rajeshtukdeo Рік тому

    Very helpful video !!

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your positive feedback! We're glad to hear that you found our video helpful. If you have any questions or if there's anything specific you'd like to see in future videos, feel free to let us know!

  • @aliakhan5998
    @aliakhan5998 Рік тому

    this post is very helpful. Is it possible that you show me how to hide a reference line based upon the year. e.g I have benchmark and threshold as constant lines for 2023 but all previous years I do not have Benchmark and threshold for my data.

    • @btprovider5561
      @btprovider5561 Рік тому

      Hi Alia, To add a Reference Line for just a period you will need to change a bit the visualisation following this steps: 1. Create a calculated field for Benchmark 2023 => IF YEAR( [Order Date] ) = 2023 THEN Benchmark END , similar for Threshold 2. Add to Filters Measure Names and keep only the Benchmark & Threshold fields 3. Add to Rows Measure Values and change them to AVG (this so that you have the correct constant value set for 2023) 4. On Marks Select the box for Measure Values and add to color Measure Names, this will create to lines only for the 2023 period 5. Right Click on Measure Values and select Dual Axis, and click on one of the numeric axis an select Synchronize Axis And now you should have the two "Reference Lines" Hope this will be helpful

  • @archanakams1905
    @archanakams1905 Рік тому

    Hi thanks for the explanation. I tried this but when I drill down from one category to subcategories. The other categories along with subcategories are showing up as well. Please help

    • @btprovider5561
      @btprovider5561 Рік тому

      Hi @archanakams1905, Thanks for watching the video. Are using the drill down from the Hierarchy or the Select Action that changes the Set Values? It will be helpful if you can tell us the steps you are taking to creat this drill down.

  • @davidesartori4354
    @davidesartori4354 Рік тому

    Thanks! What if you want to scroll up and down from both tables, in a way that they both scroll at the same time, is there a way to do this in Tableau?

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this #SkillPill! At this moment there isn't a way to syncronize the scroll between the two tables

  • @marinamilitaru9792
    @marinamilitaru9792 Рік тому

    Aveti comunitati pentru oamenii care lucreaza sau studiaza data science? 😊

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Mulțumim pentru interesul acordat acestui video! Momentan, din păcate, nu avem o comunitate care să aibă ca principal punct de interes data sciences, dar nu am spune nu unei astfel de provocări!

  • @IndrėJakaitytė-k1c
    @IndrėJakaitytė-k1c Рік тому

    Would be very helpful if you could share what your dataset looks like.

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this #SkillPill! The dataset is the one provided by #Tableau for practice/learning and is available with the installtion of Tableau Desktop.

  • @AliTwaij
    @AliTwaij Рік тому

    thankyou

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Thank for your feedback! Here you can find more #SkillPills: ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @thirdsandaime9649
    @thirdsandaime9649 Рік тому

    How about for week?

    • @chrism8955
      @chrism8955 Рік тому

      This is what I used to match up weeks year over year date( dateadd('day', datediff('year',[Order Date],today())*364,[Order Date]))

  • @zhartamad
    @zhartamad Рік тому

    Great Video, Looking to see if there is a way to make the Suffix dynamic so when a selected value is null then the suffix also displays null. So in this example when 3 is selected it shows % but if there is null value to report can the % drop with the null. Thanks

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this #SkillPill! To drop/not show the suffix/prefix you need to adjust the calculation like this IF ISNULL (Dynamic Measure) THEN "" ELSEIF Measure IN (1,2) THEN "" ELSE "%" END

  • @KarThik-tb1pl
    @KarThik-tb1pl Рік тому

    Using same technique same value split more than 1 times with different index.. any idea ?

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your interest for this #SkillPill! Can you offer us more details on what you try to achive? You can write to us email address here.

  • @cosmingaftone8464
    @cosmingaftone8464 Рік тому

    Aveți analiza dashboard pentru mai multe companii?

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Mulțumim pentru interesul acordat acestui #SkillPill! Avem rugamintea să ne transmiteți pe adresa [office@btprovider.com] mai multe detalii referitor la ce anume doriți să analizați.

  • @kammyc
    @kammyc Рік тому

    Awesome Sauce!!!! This solution worked the best. Thank you

    • @btprovider5561
      @btprovider5561 10 місяців тому

      We appreciate your positive feedback! We're glad to hear that you found our video helpful. If you have any questions or if there's anything specific, you'd like to see in future videos, feel free to let us know! Here you can find more #SkillPills: ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @harshavardhanraj3028
    @harshavardhanraj3028 Рік тому

    excellent work, no time waste straight to the point THANK YOU!!

    • @btprovider5561
      @btprovider5561 10 місяців тому

      Thank you for your feedback! Here you can find more #SkillPills ua-cam.com/play/PLQZ-_qVrXTSWBcMnvSMbC4_j-Y_WOnhyu.html

  • @fakeersabnadaf3775
    @fakeersabnadaf3775 Рік тому

    Could u plz help multiple column selection in tableau