Charts & Counters

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.

No data was found

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.

לא מצאת מה שחיפשת?
צור קשר עם התמיכה שלנו

מדריכים נוספים

grad1
Financial data analyzing hand writing and counting on calculator in office on wood desk

חשבונית ישראל – קבלת מספרי הקצאה לחשבוניות

בעקבות הנחיות רשות המיסים, עדכנו את גרסת הMybooks על מנת שתתמוך בדרישה למספרי הקצאה.
grad1
Customer-Managed Relationship Concept - Businessman Arranging Small Wooden Blocks with Symbols on the Table.

פרופילים

במערכת מייביזנס ניתן להגדיר הרשאות לפי פרופילים / תפקידים.
grad1
Businessman Leading the global world business community of network communication connected. Digital and technological convergence with abstract blue background.

זאפייר

במדריך זה אנו נתמקד על ביצוע פעולות מיוחדות במערכת דרך הזאפייר ללא שימוש באפליקציה של mybusiness כגון הוספת רשומה (לד...
grad1
Businessman using mobile smart phone. Business global internet connection application technology and digital marketing, Financial and banking, Digital link tech, big data.

Rest API

Rest API allows you to perform actions such as queries and data update.