Hi all, I am posting a scenario for the beginners in dashboard. The blog explains: selection of an item in combobox and dynamically displaying the desired objects.

Our scenario is:- Plant, material and Quantity are given, we have to make a column chart which displays Quantity Vs. Material on selection of a particular plant.

There are couple of snapshots to make things clear:-

Our original data is:-

excel.JPG

Now just insert the excel to the dashboard.

From the “Components” Tab select “combobox”  which is in category “Selectors”

A) Give a Suitable title to the combo box, here I am giving “Select Plant”

B) Now, we have to give the label items which are need to be selected, here we will select the plant and according to plan, Material Vs. Quantity chart will be displayed. Follow the snap for mapping the labels to the combobox.

label.JPG

C) Once the labels are mapped, we will select the “insertion type” as “Filtered Rows” (This will help showing the data which are in same plant but the material and quantity is different.)

D) Now, map the source data in the field:-

source.JPG

E) Now, map the destination for the combobox:-

desti.JPG

F) Now, we will select a “Column Chart” from the “components” in category “charts”

G) Now in column chart give suitable titles and select “series” and then add a new series by pressing “+” sign, map the Quantity destination to this series as a source.

column.JPG

H) Now for labels to be displayed for materials in X-axis, map the material destination as shown:-

column label.JPG

I) All work is done now, just preview it:-

prev.JPG

Please ask if any doubt !

Thanks,

Yash

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Huu Nguyen

    Nice tip. One suggestion: If you go one more step and hide any empty values in the selected range, the chart will look a lot better.

    Untitled.jpg

    Huu Nguyen

    (0) 

Leave a Reply