how about what I posted at:
The specified item was not found.
Another thing that I have done in the past is vary the level of truncation depending on the range (i.e. if showing a number of years, truncate the data to month, over a week, truncate to hours...): http://www.datadrivenconsulting.com/2011/01/tableau-as-a-dashboard-take-two/
Joe - I really like your date selector with custom slider
Hi Alex -
I like what you have done.
My first thought is that the calculated fields you have made (date chooser etc) would need to be updated manually every month...am I right?
If so, is there a way around that?
Thank's Joe for leading me in the right direction!
I want to go two more steps but I don't know if I am on the right path. In my attached file I have one file with our package prices in local currencies (tblStardollarPackages). I have made a new field for cCurrency since the original one (vCurrencyCode) was lower and the matching field in the second table (tblDailyEuroRate) is upper... :)
First tab only uses the rates. So I just show selected (filtered) currency for the date range defined by the parameters you showed how to create. I show AVG since I think that is what I should if the granularity on the date axis would be changed. Works as a clock!
Second tab shows all the currencies and the average Euro rate based on the same parameters. Great!
Then I thought it would be easy to just marry the two files and show prices in Euro based on the same average exchange rate.
Just using AVG in the formula for Price works fine but trying to use the same time span as tab 1 and 2 doesn't.
Guess I just don't know how to write formulas?
exchange_rates_6_1.twbx 539.6 KB
Can you repost the link that you referenced in your response on June 16, 2011?
Hi, The question Matthew asked Jun 16, 2011 4:32 AM is exactly what I am trying to do. As Amy pointed out, the original reply by Joe has an invalid link. I'd like to see how that is done also.
Thanks! Will check it out...
Thanks again Matthew,
I was hoping to take this a few steps further. I'd like the code to not be part of the Calculated Field but be housed in a View on the SQL server.
Current situation I'd like to duplicate:
Our reporting table contains a DateTime field with time stamp. The user selects a Report Type (Yesterday, Last Week, Last Month, Last Quarter, YTD, Custom, etc) via a Parameter. The Parameter choices are populated by a Table (separate unrelated dataset) of Report Types.
The user selection gets passed into a Stored Procedure which returns the relevant Start and End dates (another separate unrelated dataset). These dates then populate final Start and End Date Parameters for custom date selection if they so choose.
This method allows us to standardize and centrally maintain the Date Range selections across several hundred MS Reporting Services driven reports.
My challenge is the Separate Unrelated Datasets. Is this possible?
Thank you for your help,