Could you post your workbook to give it a try?
I know I saw a post or article on how to do this but I can't seem to find it. Here's what I came up with though. Create a string parameter with the desired levels of resolution (i.e. 'Year', 'Quarter', 'Month', etc.). Then, create a calculated field as follows:
IF [Date Parameter]=='Year' THEN DATENAME('year',[Tidspunkt])
ELSEIF [Date Parameter]=='Quarter' THEN DATENAME('quarter', [Tidspunkt])
ELSEIF [Date Parameter]=='Month' THEN DATENAME('month', [Tidspunkt])
Place this calculated field on the columns shelf and it should work!
Absolutely. Please see enclosed workbook. One sheet with original view and another with tested use of parameter and calculated field. So I basically want to create a fusion of these sheets, but I think my blending is messing things up.
I tried your solution Marc, but did not quite work.
I'm not sure I understand what you want to do, exactly. Can you clarify? Do you want to display the date at different levels, like month, week, day, etc. or are you trying to do something different?
If you look at the worksheet posted, I want to generate the original looking sheet, but instead of the user having to change the resolution of the time-axis manually, they should be able to do so by simply selecting by "Weeks" or "Months" in a dropdown. As illustrated in the second sheet. But doing so with a parameter and calculated field messes up my blending some how. As you'll see the temperature data is no longer correctly displayed and the green incident marks are not marked correctly.
The content and visual of sheet one "Original" is correct, but I need the elegant dropdown of sheet two.
I'm not sure what you mean--it seems to be operating as it should, and the marks seem to be in the same place--I'm not sure showing the "weeks" breakdown is what you really want here, as it is pretty difficult to read at that level.
You are exactly right, Ville. Did not ask for the fancy sizing functionality, but you are spot on
Did you have to change the blending? Do you have the sheet you created?
I wasn't sure what you are looking for so that's why there was some extra stuff.
What I did is quite simple:
1. Create custom dates for each data source
2. Edit relationships for each custom date and data source
3. Create calculated field
4. Click those linking fields active for both secondary data sources
Awesome stuff Didn't know about the "Create Custom Date" function. Learn something new every day.
Did you change that calculation from measure to dimension? And put that
into column shelf before year.
1.11.2013 16.46 "Sten Lomme" <email@example.com>
Tableau Support Community
for selecting date resolution
reply from Sten Lomme<http://community.tableau.com/people/sten.lomme.0?et=watches.email.thread>in
Forums - View the full discussion<http://community.tableau.com/message/237447?et=watches.email.thread#237447>