I have issues loading data into dashboard (my data is about 500k) - 1 year
when its about 100-200k its takes a while but it loads.
I have checked my query from my db2 - its pretty fast (3min) for 1 year.
Im thinking if I separate the dashboard it will reduce the delay and improve performance.
I need to test out to see if it works. So I want to create 1 dashboard that shows nationality,region,person name,
and then drill down to their particulars on another dashboard.
Im testing without any parameters.
You can create two dashboards. In the first dashboard, let say you want to show by nationality,region,person name. From dashboard 1, you can set parameter using action to dashboard 2.
In Datawatch Desktop, you can check the sample dashboard (How to Action). I hope this will help you.