Skip to Content
Author's profile photo Former Member

Dynamic column chart using Filtered rows

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

Assigned tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo G.S Ramanjaneyulu
      G.S Ramanjaneyulu

      Nice one really helpful for Beginers

      Author's profile photo Former Member
      Former Member

      Nice Presentation Keep up the Good Work!!

      Author's profile photo Former Member
      Former Member

      Nice explanation thanks for sharing the document Yash.

      Author's profile photo Former Member
      Former Member

      Excellent explanation Yash

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thankyou

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Good one. 🙂

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      Really useful  🙂

      Author's profile photo Former Member
      Former Member

      Nice Blog Yash 🙂

      Keep Posting !!

      Regards,

      Gokulkumar RD