Mybusiness's charts allows you to easily create various database-driven graphs and charts.
Learn how present your information in a neat and professional way; you can choose the chart's layout, theme and design or create your own.
Settings- Set up your chart
After dropping your chart widget into place, a new window will open allowing you to set up your chart.
As you can see below, you will be able to choose the layout, fields, function and more.

Table – Select the table you would like to draw the data from.
Chart type – Select the chart layout from one of three options: bar, pie or line.
Chart label – Select the field of data from your table that will act as your X-axis.
Value function – Select the function you would like to use on your Y-axis.
Chart value – Select the field of data from your table that will act as your Y-axis.
Chart category – Select a category for your chart.
Format – If your field of data is a date type you can select its format (by year, month, full date, etc.)
In our next example we will create a line graph with a category. We will use our "cargraph" table and a "line" type layout.
We would like to create a chart showing the price of a certain model per year. As you can see, we have chosen our X-axis to be per year, the price field to be our Y-axis with a sum function, and our model field to be our category.
Filter data
As you may have seen with our other widgets, we allow you to filter the data before presenting it. The same thing applies to the chart widget.
In our example we have filtered the prices so only cars with a price above 20,000 will be included in our chart.

Design your chart
You can choose one of the ready-made designs or add your own design in code (json).
If you wish, you can choose one of the designs and customize it with json.

Our final result
As shown above, you can use various types of graphs in one page and play around with the different available options. (Our example graph, titled "Price by model per year," is depicted below the top two graphs in the following picture.)

Counter widget
Allows you to create a database-driven dynamic counter based on numeric data.
The counter widget allows you to count and process certain fields in one simple step; while creating your counter, as with the chart widget, you will be able to choose it's design, function and behavior.
Settings- Set up your counter
After dropping your counter into place, a new window will open allowing you to set up your counter's behavior. As you can see below, you will be able to choose the design, function and more.

Table – Select the table you would like to draw the data from.
Function – Select the function you would like to use (count, sum, average, min, max).
Field – Select the field you would like to process.
Font design- Select your font settings.
Format- Select how you would like to present your counter (0.0 , 0,0 , 0.00 etc.)
Filter data
As you may have seen with our other widgets, we allow you to filter the data before presenting it or with a search form. The same thing applies to the counter widget..
In our example we have filtered the our "active" field so only users that are active will appear in our counter.
