If Category is dynamic, here's what you can do:
create table CATEGORY ( ID int NOT NULL AUTO_INCREMENT, NAME varchar(16) NOT NULL, PRIMARY KEY(ID) ) create table MONTHS ( MONTH int NOT NULL AUTO_INCREMENT, PRIMARY KEY(MONTH) ) create table CATEGORY_SUM ( ID int NOT NULL AUTO_INCREMENT, CATEGORY int NOT NULL, MONTH int NOT NULL, PRIMARY KEY(ID), FOREIGN KEY(CATEGORY) references CATEGORY(ID), FOREIGN KEY(MONTH) references MONTHS(ID) )
Then fill your MONTHS table with all the months you need
Then you can do something like
SELECT * from CATEGORY_SUM RIGHT OUTER JOIN MONTHS ON CATEGORY_SUM.MONTH = MONTHS.MONTH order by CATEGORY_SUM.CATEGORY, CATEGORY_SUM.MONTH
I leave to you to get the actual name of the category into this query
- Building dynamic number of arrays to display in Highchart
- trying to use highchart xrange to display large number of categories
- display highchart with dynamic data
- Display points with minimum number in HighChart
- How to display highchart series line marker symbol from tooltip formatter?
- HighChart Shared Tooltip Number Formatting
- Highchart dynamic creation - not rendering properly
- How to display highchart y axis with constistant data
- Django - can't get highchart to display data
- Add gridline on dynamic marker highchart
- Using Highcharts display donut hightchart having dynamic data
- Highchart donut pie - Is there a max number of slices
- Highstock - display number of week
- Display Image on xAxis in highchart
- Highchart datetime x-axis : display end of month date instead of first day of month
- Display percentage on tooltip highchart Angular 2
- How to fill dynamic json value in drill down highchart
- Highchart angular directive doesn't redraw from dynamic (ajax) data table
- Highchart - Display JSON Data - MYSQL / PHP
- How to grab correct highchart number in selectors using Selenium Webdriver with Python with several charts on the page?
- Is there limit on the number of data points to plot HighChart
- how to display 2 same highcharts without duplicate the code
- Dynamic number of highcharter plots
- HighChart Sparkline Chart with dynamic data for the table
- Highchart JSON pie chart display Slice undefined
- Tooltip doesn't display on highchart graph
- Highchart doesn't display in IE7/8
- how to add dynamic xaxis category label name in new point highchart
- How to do In highchart tooltip display the first 100 characters and then say "See more .."?
- How to read and insert correct highchart number in selectors using Selenium Webdriver with Python?
More Query from same tag
- HighCharts: pie slices need background images
- Highstock setExtremes with a custom range selector button
- Solid Gauge Highcharts data Spreadsheets
- Highcharts: cutom tooltip (useHTML: true) z-index issue over resetZoomButton
- How can you add flags to points on a graph
- Displaying date on the x axis with Highcharts using ASP.NET MVC
- Load JSON file into highcharts to draw a Line Chart
- HighStocks - Adding 2 charts on same page
- How to make a function call every few seconds in c#?
- Add stacked border color in Highchart?
- Highcharts: passing additional information to a tooltip
- Why is my JSON formatting different from HighCharts examples?
- I can't use gauge-solid and spline chart at the same time by using HighCharts
- is it possible to add a filter to highcharts?
- highcharts - changing color of area depending on y-value
- x-axis is not completely visible on highcharts
- How can I inspect the Highcharts tooltip in the Chrome inspector?
- Highcharts X-Axis value on top of stacked column
- How to show a loading state before show the complete page?
- Highstock error Invalid date
- Highcharts stacked bar data from CSV
- Highstock X-Axis: Categories in Place of Time
- How to dynamically update highcharts using jQuery UI sliders
- HighStock datagrouping approximation functions
- Axis Label Alignment in highcharts
- Highcharts change colour of individual bar
- How to remove and add Plotlines in HighCharts
- Hide Highcharts error's in console
- how to add new index Highcharts column drilldown chart