Limit date ranges without changing the model

[Anonymous]

Hello,

Is there a way to limit data to a specific range without editing the model we're using or dropping/re-adding tables on the dashboard?

For example:

The data in my model contains data through Oct. 1.  This is fine for most dashboards, however, is it possible to limit data within dashboards to only show data through July 1?

I'm using a binary load in my dashboards to load the model with a separate master calendar in each dashboard.

Thank you in advance!

[Anonymous]

if you use set Analysis you can deine other date ranges as well

sum({<mydate={'<=July 1'}>}value

you Need to define your proper fields out of your data model

[crystles]

If you have a separate master calendar with each dashboard, you can simply put a where clause at the end of the master calendar load to limit the dates being pulled.

[Anonymous]

Is there a reason that you can't just make selections?

[Anonymous]

Some of the data in the model is refreshed quarterly and other data is updated weekly.  These tables all link together but there are holes when use data from the quarterly updated tables since the data, from the tables that are updated weekly, have nothing to link to in the quarterly updated tables.

[Anonymous]

Thank for your reply crystles.   This has been attempted and works to a point, however, the data is still able to be filtered outside of the master calendar date range

[crystles]

So are the weeks that are being loaded, outside of the quarters that are being loaded? It seems each week would belong to a quarter. And if the quarters are loaded first, then the weeks would belong to the quarters that are already loaded?