Large amount of data - whats the best way to show it?

[#1]

Afternoon all,

I'm after some advice please. I'm currently building a demo to form part of a business case.

I have a vast amount of warehouse pick data that I want to represent. I have about 4 weeks worth currently although this will only ever get bigger.

Previously I have 1 weeks worth and I had a nice stacked bar chart detailing the amount picked, by date/hour.

As soon as I loaded to new data I think the amount of data caused the screen to fail.

I think what I'd like to do is create some sort of button/variable that only loads 1 weeks of data at a time, and the user can click next/previous to load the next set of data.

Is this possible, if so can you please give me some guidance.

Or, if you have any other ideas, I'd like to hear them.

many thanks

Dave

[Anonymous]

My advise would be to load all the date but show only one week.

You can do this by using the "Always One Selecte Value" in the properties of your week listbox.

I hope it is something you can use.

Good Luck,

Dennis.

[#3]

Hi, Many thanks for this.

I can see exactly what you mean, but its grey'd out for me.

The field I need to use is showing a key symbol next to it - has this anything to do with it?

It is not a key field in my data, but actually calculated from the pick datetime field

thanks again for any advice offered

Dave

[Anonymous · Accepted solution]

That option is greyed out when there is more then one value in your selection.

Try to select one value and then go to the properties.

Does that work for you?

[#5]

Excellent - many thanks

Dave