Hi to everybody,
first let me describe what i want to do:
I want to display the frequency of the entries in a mysql datatable to a chart
(bar graph).
For example the table contains the entries: 5 times entry1, 8 times entry2 and 15 times entrie3. I want to display that to a chart(bar graph). I think you can image how it would look like. The X-Axis contains the names of each entry and the height of the bar represents the frequency of that entry. I need to sort the bars by frequency (most recorded entry first)
Can somebody tell me if there is an easy way to do this? I dont know if the best way is to count the entries and extract the count number to an integer. Anyway i have no clue how to do this. Maybe there is a direct way to connect a chart to a mysql database and display the data in the desired way?
I would appreciate it if somebody would give ma a suggestion, Thanks a lot.
What I have tried:
sql statements: Count, Groupe by, DESC
Reading about Charts in C#