How to set default Date Range from (Today - 5) to Today. i.e., eg: Date Range : 13 - 07 - 1992 to 17 - 07 - 1992 as a default

0 votes
Jul 17 in Tableau by Ushasree
• 120 points
192 views

Thank you for answering.

I mean what i need exactly is, 

Here, we are having fltdata (which gives the dates) .  for that selected date range i need the volume, high price, low price, and all..  only for that selected range.   Here, I am confused what parameter or Calculated field i need to create as i am new to tableau.  Please do help.  Thank you

You can use the calculated field as you created by providing offset as -5 instead of 5 to get 5 days back.

Then create a new calculated field to compare dates if it lies between today and default and group them.
Could you pls tell me how to group them ?
If any doubt, do revert back.

2 answers to this question.

0 votes

Like I said in the comment, 

Create a CF like below [ Replace Fitdate instead of Order Date in your calculated field] 

Now drop the created field instead of [Fitdate]. You will see dates that will fall within the range of these dates.

answered Jul 17 by Cherukuri
• 25,900 points

Hi Usha, I tried a similar problem as yours, but I couldn't achieve the expected result. Maybe you can try this way, See this video it explains by swapping sheets to hide the parameters.

https://vimeo.com/107352893

I will go through it.

Thank you
I found a solution for all my problems. i.e., Story lines.

I can hide sheets, filters by creating dashboards and merging those dashboards and moving it into story

Thank you
Thanks for sharing. So you used the last 5 days in one slide and Custom days parameter in another slide in the story and then hide the other parameter. Am I right?
Exactly... it worked for me..

Thank you
0 votes

A set can dynamically change as per condition, so you can try sets instead of creating parameter and calculated field.

Use the above field to show default last 5 days.

answered Jul 30 by Prajwal
Thank you so much..

It resolved for me..
Hi,

Im was trying for a similar problem to choose a parameter to project status wise students or all students for student dataset. You used stories to show and hide parameter, but it wont show in the same page right? did you find any other way.

In this story i created,  Custom and Default.  Can i add third Caption box ?  

Hi Kavitha,  I didn't understand what you asked me exactly.  I used story to hide parameters.  Yes, it's not in same page.  It's from two separate dashboards.
Ohh! I got it.

My question was i want to choose batches or all students like you have to choose between custom and default dates.

Thanks.

Related Questions In Tableau

0 votes
1 answer

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 7, 2018 in Tableau by Nitish
• 630 points
53 views
0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by Atul
• 5,530 points
617 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How can I create a second sheet which is filtered to 8 days ago,

Following are the steps you can follow: Create ...READ MORE

answered Jul 11, 2018 in Tableau by Atul
• 5,530 points
38 views
0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by Atul
• 5,530 points
38 views
0 votes
1 answer

How to get past N months date from data source?

Hi, this is a one solution to your ...READ MORE

answered Mar 1 in Tableau by Cherukuri
• 25,900 points
66 views
0 votes
1 answer

How to calculate work done for a given date or period of time?

Hi, Follow these steps: As per you question since ...READ MORE

answered Apr 1 in Tableau by Cherukuri
• 25,900 points
25 views
0 votes
3 answers
0 votes
1 answer

How to set Actions from sheet to Dashboards

Hey, The below Filter can be used to navigate from ...READ MORE

answered Feb 28 in Tableau by Cherukuri
• 25,900 points

edited Feb 28 by Cherukuri 37 views