BlobCity DB

BlobCity DB

An open-source multi-model database, designed to meet a wide variety of data storage, fast data retrieval and analytics requirements.

Get Started    

Charts Overview

BlobCity Visualisation, chart types and creating your first chart

BlobCity Visualisation, allows for feeding data stored in BlobCity DB, directly to web based real-time charts. The charts are pre-integrated for Database Cloud customers and available as a separate package for On-Premise customers. The charts are a chargeable service. Currently basis visualisation and charts are free with a Cloud plan of BlobCity DB.

Basic Charts

  1. Pie
  2. Line
  3. Bar
  4. Column

Sample Data

Collection: Org.Persons

pid
age
dept

1

32

Electrical

2

38

Computer

3

26

Computer

4

46

Electrical

5

34

Maintenance

6

51

Electrical

7

43

Maintenance

8

29

Computer

9

37

Electrical

10

27

Maintenance

The above table shows data present within Org.Persons. Charts in this tutorial are plotted on this table.

Creating a Chart

{
  "key": "xxxx",
  "type": "column2d",
  "chart": {
    "caption": "Persons by Department",
    "xaxisname": "Departments",
    "yaxisname": "Person Count"
  },
  "query": {
    	"ds": "Org",
      "collection": "Persons",
    	"xaxis": "dept",
      "yaxis": "count(*)"
  }
}

API Endpoint https://visual-api.blobcity.com/rest/v1/charts/new

key: Is the unique API key for your account. This is a mandatory parameter that helps the system verify your identity and create the chart within your account. If you loose your key, please change it immediately using the cloud admin portal.

type: Corresponds to what type of chart you desire to plot. A complete list of chart types are listed here.

chart: Contains meta information related to chart. Items in this section specific chart titles, captions, legend names, colouring and thumbing options and many more. A complete list of supported chart parameters can be viewed here.

query: Optional parameter. This must be used if you desire for the chart to directly query data from the database. The query object must specify the datastore, collection, the columns in collection, aggregate operations if any and filter criteria if any. The above example does not include a filter criteria. A complete overview of support queries can be found here.

Charts Overview


BlobCity Visualisation, chart types and creating your first chart

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.