Dashboard prompt and data loading
I need some help with a dashboard.
I have a dashboard with:
1. a dashboard Prompt (all columns constrain the others automatically)
and
2. a Pivot table (rows of data is approx 16K and increasing)
It runs just fine.
The only issue I have is that every time I load the dashboard it takes quite a bit of time to load everything by default (all 16K rows of data).
Is there any option either in the pivot table or dashboard properties that simply loads the dashboard prompt first and when the user has selected his filters and clicks on GO, only then should the filtered data load.