Hi Sir, Very neat and clear explanation. I have a question sir, asked by one interviewer to me. "We have 2 parameters, one is 'start date' and one is 'end date'. Once if I selected start date and end date, then I have to get the data (between these dates) of current year's and as well as the last year's data in between the dates entered in parameters". Will you plz clear this..
It very simple if you can bring the selected date from Start date and end date. By adding " -1" in Year part of the output result to get last year data in the Calculation.
Need Help : if I created a dynamic 13 month rolling filter by creating calculated field datetrunc and parameter on date. How can i trigger another filter which can give me value (comment for that month) of selected month which i am rolling in for. Cause its messing up the current month value as as its still taking up the value (comment for that month) and showing for all 13 month months.
Create a parameter called Select Month; this parameter controls what the Marks Card label shows on the visualization • In this example, I selected February in the parameter, therefore only Sales values are shown in the visualization for February; if I pick January for example, then only January sales will be labeled on the line chart ..kindly tell me how to do this
Hello Sir, I have one question. Please tell me how to create a single value dropdown list for the parameter view instead of a slider? Whenever I'll select one month it should show me the last 11 months in option. Please help me out. Thank you :)
Thanks a lot....ufffff....all my date gone from morning because of this.Now i came out of itttt,thanks!!!! 🙏
Fantastic solution
Excellent explanation.Thank you so much.
Excellent explanation. Keep going...
Thank you for wonderful feedback
👍👍 .. Thanks for sharing
Welcome
Thanks my friends
Verey Level 😎
Thank you so much.
Welcome
Hi Sir, Very neat and clear explanation. I have a question sir, asked by one interviewer to me.
"We have 2 parameters, one is 'start date' and one is 'end date'. Once if I selected start date and end date, then I have to get the data (between these dates) of current year's and as well as the last year's data in between the dates entered in parameters".
Will you plz clear this..
It very simple if you can bring the selected date from Start date and end date. By adding " -1" in Year part of the output result to get last year data in the Calculation.
Need Help : if I created a dynamic 13 month rolling filter by creating calculated field datetrunc and parameter on date. How can i trigger another filter which can give me value (comment for that month) of selected month which i am rolling in for. Cause its messing up the current month value as as its still taking up the value (comment for that month) and showing for all 13 month months.
Pls guide on adding All option under parameter,
If user selects all option, then it show last n month based on current month or max( order date)
How can we show by default previous months data? Can you please help me out in that it's urgent for me
Create a parameter called Select Month; this parameter controls what the Marks Card label shows on the visualization
• In this example, I selected February in the parameter, therefore only Sales values are shown in the visualization for February; if I pick January for example, then only January sales will be labeled on the line chart ..kindly tell me how to do this
Sir need rolling months box ,like where can i put 1,3,6,7,9,22etc
I didn't understand what you are asking. Can you please eloborate
@@Rayapati i need box or drop down where can i put rolling month number like 3,6,9,12,36
@@bimalpatel7758 Use Parameters. That is the best way to get customized numbers like this
Yes but i dont know how to create can you pealse send me link or video so i can do
Helped.
Can I just change the date diff aggregation to avg from sum instead of converting it into measure. the result looks same
Can we display top 5 and bottom 5 sales in tableau using set? Please answer my question it will be helpful for me.
ruclips.net/video/5oa3X-y-HFk/видео.html
Hi sir,
If we want last & feature 53 weeks data
I don’t have a date field , how can I still achieve the monthly data for 12 months
How do you plan to identify the data in the current year? If you have a way to do that then yes we can get YTD data
How to display top 5 and bottom 5 sales in tableau? Please answer my question it will be helpful in interview
ruclips.net/video/5oa3X-y-HFk/видео.html
Hello Sir, I have one question. Please tell me how to create a single value dropdown list for the parameter view instead of a slider? Whenever I'll select one month it should show me the last 11 months in option. Please help me out. Thank you :)
Convert the parameter range to a list.
I only show last 12 months no matter which month I choose.
Did you use the Parameter as explained? Provide the Tableau public link of the workbook. Will look into it