How to show data in bar graph

[LY_10691079]

Suppose I have list of hospital in the dropdown and if I select a a hospital from the drop down it displays associated data in grid format and these columns are like 1. Doctor Name 2. Department 3.Specialization NOW what I want is I want to count these individual column unique data and show that in a Pie chart or bar chart and that chart should also vary based on hospitals how can I achieve this in Thingworx 9.1 or later version

Thanks,

Lav

[PEHOWE]

@LY_10691079 ,
I get the idea of a dropdown (hospitals), When one is selected you display a list which shows Doctor Name, Department, Specialization, which apply to that hospital.

What i don't get is what are you counting? What gets displayed in the pie chart? (number of Doctors, Number of Departments, Number of Specializations)

Something else which I do not understand?
You also want the chart to change , some will be a pie some a bar, What is the deciding factor?
 

[PEHOWE]

Hello @LY_10691079 , 

I created a test case which has many of the features in your discussion. It is just one approach and will not meet all your needs. If you have questions Please post them and someone will provide more details.