PJ Analytics

Пікірлер

@gauravghosh8002 3 ай бұрын

I thought Cross DB Join you showed as Blending . Sir then What is the difference between Cross DB Join and Data Blending, could you please make a seperate video please .

@pjanalytics 3 ай бұрын

Cross DB Join and Data Blending both are different. Yes will explain in separate video

@gauravghosh8002 3 ай бұрын

Thanks for the questions but it would really great if you answers to those questions sir .

@pjanalytics 3 ай бұрын

Sure..in coming video

@HarreshPujari 5 ай бұрын

Thank you, I was looking for comparing it in form of actual numbers grid view

@pjanalytics 3 ай бұрын

You can show as grid also. Convet to cross tab

@shivamsharma-ws7cq 6 ай бұрын

Thanks Sir

@sheltonjeanbaptiste4448 7 ай бұрын

Thank you

@SimLab-b7e 7 ай бұрын

Hello, please help me with the solution - the year starts from 1st june till 31st may then how to calculate YTD?

@pjanalytics 3 ай бұрын

Sure .. try below calculation [Order Date]>= DATEADD('month',5, DATETRUNC('year' , [Order Date (copy) Parameter])) and [Order Date]<=[Order Date (copy) Parameter]

@adityabikkavilli3539 7 ай бұрын

Hey PJ , nice video Can we use a calculated field to identify new records in incremental refresh

@pauldcosta8172 8 ай бұрын

Hi PJ, Is there a way to add conditional formatting on two dimensions. For example, I have program field which is a calculated field like Event, Start, etc and another dimension which Open Percentage. I need to color code by above benchmark which is green and just met which amber and below which red. Can I do this in tableau. Thanks in advance

@pjanalytics 8 ай бұрын

Open Percentage is dimension or it contains Percentage? if possible create the tableau sheet with some dummy data and publish it on Tableau Public server and share the url. It will help to understand the exact problem

@matheusvasconcelos7025 8 ай бұрын

hello PJ, nice video! so, this method works when i call the datasource refresh with tableauserverclient to automatize my datasource refreshes?

@pjanalytics 8 ай бұрын

good one...but i do not think this functionality is available as of now

@PGJAS 8 ай бұрын

I am having whitespace in-between rows. How to remove that?

@pjanalytics 8 ай бұрын

try to increase the size of bar

@PGJAS 8 ай бұрын

@@pjanalytics It's working...thanks

@rakeshgoud_hi 9 ай бұрын

Excellent..😊

@robertwest863 9 ай бұрын

😒 *PromoSM*

@swathijarubula7433 9 ай бұрын

Hi sir, I am trying to implement one scenario like user selects fy year,quarter and month in the dashboard level required to provide filter level options.based on the user selected fy year,quarter, month sales and previous year same selected date range sales need to show in kpi level. I have 4 years of data.I am struggling to implement. Can you please explain this scenario. Thanks in advance.

@pjanalytics 9 ай бұрын

Hey Let me understand your scenarios. you want to provide 2 dropdown option ? in first one user can select either (Year or Quarter or Month) then in second drop (all year or all quarter or all month) right?

@swathijarubula7433 9 ай бұрын

@@pjanalytics Required to provide 3 filters in dashboard like below, 1. Fy year filter have 2021,2022,2023, 2024 options 2. Quarter have q1,q2,q3,q4 3. Month have from April to March Based on these 3 filters Required to show sales and what ever selected for that previous year example user selected 2022,q1,April then this is current year and 2021,q1,April is previous year

@Mayakevin 9 ай бұрын

Thank you sir, this video is very useful for me. Please upload more videos like this.

@pjanalytics 9 ай бұрын

Glad to know.. sure more videos will be upload soon

@SAMDANIMOHAMMED-j3p 10 ай бұрын

Nice bro❤ Can you make all server related video series

@pjanalytics 10 ай бұрын

Thank you.. Sure will upload on server topics also

@Mayakevin 10 ай бұрын

Very informative and helpful

@brijeshsingh6198 10 ай бұрын

❤

@pjanalytics 9 ай бұрын

😊

@adarshjain8319 10 ай бұрын

Very helpful and easy to understand

@adarshjain8319 10 ай бұрын

Very helpful and easy to understand

@pjanalytics 9 ай бұрын

Thank you

@shree7345 10 ай бұрын

Nice tricks

@pjanalytics 9 ай бұрын

Glad to see

@jeffreypeterson5909 10 ай бұрын

Hi PJ, good video! I have a question - when someone first opens the dashboard, will it load all data in the background, THEN filter it to via the user filter? Or will it load ONLY the data from that user filter? I am asking because of performance - if we have one dashboard for lots of different countries, and someone from a specific country opens it, will it load all data, then filter? Or only load their country's data?

@pjanalytics 10 ай бұрын

Very good points.. But you can observer data is restriction at sheet level not at data source level. If you want to restrict the data at Data source level then you can think about join. Let me know if you need details

@RevanTadikonda 11 ай бұрын

Could you confirm if we can we achieve this using tableau online/web version please?

@pjanalytics 10 ай бұрын

Web version is not designed for that purpose.

@radhika1955 11 ай бұрын

please create more on Sql sir

@radhika1955 11 ай бұрын

Very helpful.. Thanks alot

@radhika1955 11 ай бұрын

Thank you so much for the tips

@pjanalytics 11 ай бұрын

Hope it helps you

@shree7345 11 ай бұрын

Very Informative .. Please create more on scenarios

@TravisTraps Жыл бұрын

This was massive! I liked this approach way more than using joins, entitlement tables, and other methods of RBS. Very quick and easy, you the man, Pj!

@pjanalytics 10 ай бұрын

Thanks . but yes there are some other ways to implement it that's depends on scenarios

@mailtosom Жыл бұрын

Hi Piyush, Thanks for the video. Question: Is it necessary to create the Username calc field before creating the IFMEMBEROF calc field

@pjanalytics 11 ай бұрын

Hey, not really required you can directly use in ifmemberof

@carolinaalvarez1775 Жыл бұрын

What about Row level Security using a parameter instead of a filter?

@pjanalytics Жыл бұрын

Can you elaborate ? How using parameter

@carolinaalvarez1775 Жыл бұрын

@@pjanalytics Ok so I have a dashboard and created a parameter with hospital names. The user can select Inbound or outbound patient data(also a parameter). The hospital parameter has 7 hospital names (we only need to see inbound/outbound for those 7). if I clic inbound and select a hospital it shows all inbound patients of that hospital. Problem is! each hospital employee are supposed to see inbound/outbound for their location only not the other 6 hospitals. I cant filter the hospital with just a filter bc I use a parameter to define inbound/outbound. I hope u understand

@pjanalytics Жыл бұрын

@@carolinaalvarez1775 is it possible to share workbook with dummy data that will help me to understand it clearly

@carolinaalvarez1775 Жыл бұрын

Thanks! super helpful

@pjanalytics Жыл бұрын

Thanks it means alot

@balajeer4432 Жыл бұрын

My scenario is like it has been implemented in our application by so how can i restrict this scenario

@pjanalytics Жыл бұрын

You can restrict at workbook level

@balajeer4432 Жыл бұрын

@@pjanalytics how?

@sahiladya8473 Жыл бұрын

How to test access for an user on tableau server?

@pjanalytics Жыл бұрын

You can check directly on server

@explorenations892 Жыл бұрын

how can I plot the current week and Previous week Sales lines on the same graph with current weekdays plotted on the X axis ?

@lawrenciaatakora Жыл бұрын

Thank you!

@JUNAIDAHMED-p9l Жыл бұрын

Hi, may i know the difference between user filter and user function when we should use each

@pjanalytics 3 ай бұрын

Both are different , user functions will provide the details of logged in user. User filter will filter the data based on user-data mapping

@balrajvirdee1087 Жыл бұрын

Thanks brother 👍🏽

@ome9034 Жыл бұрын

what discrete does ?

@gowthamkumar5197 Жыл бұрын

very well explained

@divyasathyam5939 Жыл бұрын

Make a video on all filters

@butterflymantis Жыл бұрын

Can we get the group in ldap active directory

@RadhaKrishna1111-r7j Жыл бұрын

perfect answer.thanks for the video.

@pjanalytics Жыл бұрын

Thank You

@shubhamawale4881 Жыл бұрын

We are going to work on a project, but I am confused that the mail id of the licenses I going to purchase should be my organization or client organization because I need to deliver in the end, Can you please help me out?

@himachaudhary5531 Жыл бұрын

Good explaination, however when I tried the same my filter shows null instead of true false, why would that be? can you please help me. But all the calcs for YTD, QTD and MTD are working fine and pulling correct dates

@pjanalytics Жыл бұрын

Check whats your current date and data

@himachaudhary5531 Жыл бұрын

@@pjanalytics I did and all my calcs are working for 2023 for YTD, QTD and MTD. But the calc to tie the parameter to the YTD, MTD and QTD shows null instead of True and False.

@pjanalytics Жыл бұрын

@@himachaudhary5531 share you calculation that is connected to parameter

@brijeshsingh6198 Жыл бұрын

Great job bhaiya❤

@pjanalytics Жыл бұрын

Thank you

@knraju9652 Жыл бұрын

super bro

@pjanalytics Жыл бұрын

Thank you

@amitsingh-dw5vm Жыл бұрын

Awesome content, thanks for this very much needed.

@pjanalytics Жыл бұрын

Thank You

@sweetyagrawal1487 Жыл бұрын

Nicely Explained

@pjanalytics Жыл бұрын

Thank You

@nishashashi24 Жыл бұрын

Thank you detailed explanation 👍

@pjanalytics Жыл бұрын

Thank You

@dawaronline Жыл бұрын

but when there is the same value in one of your measures how can we sort the customer name to the second measure. so essentially setting an order for the sorting.

@pjanalytics Жыл бұрын

You mean multiple customer having same value for a specific measure?

@dawaronline Жыл бұрын

@@pjanalytics yes exactly. like i want it to sort first on measure 1 but if there are duplicate values in measure one then sort by measure 2

Ең жақсы KZbin

Пікірлер