Dashboard changing in real time

[richard_chilvers]

Hi

I would like to create a dashboard where the objects will vary every time the data is reloaded.

My data would be sales of products, and the dashboard would show only products which have sold 100 items or more today.

Each product would show as an object (eg. gauge chart) giving details of sales today, last week, YTD. So the dashboard might show no products, or quite alot ! It is an overview of how sales are going.

But I do not want to restrict the data on the script because I will have tables of information for all products elsewhere in the model.

Any thoughts?
Thanks

[#2]

Hi,

in my opinion: When there is no product quantitiy > 100 sold in 1 day then display a relevant message on screen.

But first make a table in loadscript with the products which are sold more than 100 times the last day and display them (in a trellis?) graph or barchart....

good luck

F.

[avinashelite]

Hi Richard,

To get the real time data go with DIRECT DISCOVERY concept to achieve this, please refer this document.

[richard_chilvers]

Hi

Thanks for your reply.

But getting the real time data is not my issue.

What I'd like help with is how to create a dashboard page which might show 1 product or might show 15 (or more) products, depending on what is selling well.

Regards

[#5]

Hi Richard,

you can show them in a graph (barchart) and show them when more than 100 are sold. with Product as a dimension and sum(QTY) as an expression.... or I'am missing the point?

hth

F.

[richard_chilvers]

Hi Felix

Its my fault - I haven't clearly given the full story ! Otherwise I would probably use Dimension Limits in the way you suggest.

What I want to show on my dashboard is only those products that are selling well (eg. more than 100). But for each of these products I want to show other details, for example what are the most popular sizes, how many sold yesterday, last week, last month, compared with targets etc.

So each product would have its own 'chart' on the dashboard.

Any ideas are welcome !

Thanks

[#7]

Hi,

sounds like you have to make a list (box) of these particular products and let the users select 1 and show the details like you want.

hth

F.

[richard_chilvers]

Yes - that would work quite well.

Regards

[#9]

good to know that in addition of a listbox you can add all kind of info/expressions for a quick overview of the products... lots of possibilities!

goodluck!

F