with cte as( select table1.*,ROW_NUMBER()OVER() as x1 FROM table1 ),cte1 as( select category,x1 FROM cte where category!='Null1' ),cte2 as( select category,x1,COALESCE(LEAD(x1)OVER()-1,(select COUNT(*) FROM table1)) as x2 FROM cte1 ) select cte2.category,cte.Brand FROM cte2 JOIN cte ON cte.x1 BETWEEN cte2.x1 and cte2.x2; Mohit sir,if you find my query correct then react on my query,i just update null tonull1 to reduce chance of error
Bro atleast provide create & insert statement in the description box. So that We can practice from our side. Take this as a suggestion. Keep it up this sql series.👍👍👍👍👍👍
@@teepireddydeepika8169 for 1 year you need to arrange college id card, it is for students only , they will share 16 digit code that will be valid for next 1 year
Hi Dear.. I'm new to tableau development. I have a requirement to display custom week filter like week start date & end date from transaction date followed by.. 'week 1- 01/01/2023 - 01/07/2023'. I could able to do this by concatenating respective fields. Now my concern is all about .. To display Max week to be selected by default in dashboard. Please let me know if there is a way to filter Max week by default.. As custom week will be in string format after doing the work around and concatenation. Thanks Sai.
@@mohittyagi9141 Thanks a lot dear.. I could able to sort this issue by exploring tableau via google Actually then I was new to Tableau, hence couldn’t implement that. Let me brief you.. a custom field was expected to represent the date range for instance like ‘Wk1: 01/01/2024 - 07-01-2024’ which represents week 1 like so on.. This was used in a dynamic lable of Chart
i am trying same formula but it return null value the version is 2022.3.1 and our data is from 2018 to january 2023 SO DATE(DATEADD('month',3, DATETRUNC('year',{MAX([Order Date])}))) this formula return value is 01/04/2023
Could you perhaps help with "Same periode Previous Year" in a financial year (April-March), for example i want to compare sales from 4/1/2022 till 8/9/2022 to 4/1/2021 till 8/9/2021. I want to see growth on a daily basis Thank you so much for your help!
Hi Mohit, Please help me with this query: In the viz i want to show region with highest profit as a KPI. if 'central' has got highest profit then only central show be in that KPI. I am using this calc but getting error: IF ({ FIXED [Region]: SUM([Sales])}) = SUM([Sales]) THEN [Region] END thanks in advance
This video has been very helpful. How would I separate the action filter from all the graphs in my visualisation ? Ideally I would like to connect the filter used in the map to just two of the graphs in my visualisation. Is there anyway of doing this? I have also sent an email explaining the issue I'm having with the link to my viz, your feedback and help would be much appreciated :)