Visual Reports: MongoDB, PostgreSQL and GitHub apps are available | Targetprocess - Visual management software

2 weeks ago

Visual Reports: MongoDB, PostgreSQL and GitHub apps are available

You can subscribe to our monthly newsletter here:

Thank you for subscription!

We have added the possibility to visualize data from MongoDB, PostgreSQL and GitHub.

Using MongoDB App

visual-reports_mongodb

  • Setup account

    Start with creating a new report, select MongoDB app, provide the name of connection and connection string to MongoDB. You can read more about connection string here.

    Form MongoDB


  • Configure data settings using MongoDB collection source type

    You may proceed with selecting collection source type if the records count supposed to be retrieved are less than 200,000. It is possible to limit the count of retrieved rows by applying query or by providing limit with ordering. We have imported Stocks Dataset to "stocks" MongoDB collection for this example.

    configure-mongo-soruce

  • Create the chart for retrieved collection

    collection-chart

  • Configure data settings using MongoDB aggregation pipeline source type

    Alternatively, you may proceed with configuring aggregation pipeline to build the same chart. It is useful in the case when records count supposed to be retrieved are more than 200,000. It can be a bit complex since requires knowledge on how MongoDB aggregation pipeline works, read more about that here. I prefer to use some GUI client (it is MongoHub in my case) for creating and testing pipeline before pasting it into the source form, but it is not necessary if you are MongoDB pro.

    [ 
        { $group : { _id : { company: "$company", date: "$date"}, price: { $sum: "$price" } } }, 
        { $project: { _id: { $concat: ["$_id.company", "-", "$_id.date"] }, company: "$_id.company", date: "$_id.date", price: "$price" } }
    ]

    mongo-pipeline

Using PostgreSQL App

visual-reports_postgresql

  • Setup account

    Start with creating a new report, select PostgreSQL app, provide the name of connection and connection string to PostgreSQL. You can read more about connection string here.

    postrge-account

  • Configure data settings using PostgreSQL table source type

    You may proceed with selecting table source type if the records count supposed to be retrieved are less than 200,000. It is possible to limit the count of retrieved rows by applying query or by providing limit with ordering. We have imported Flowers Dataset to "flowers" PostgreSQL table for this example.

    postgre-table

  • Create an awesome chart

    flowers-postrge

  • Retrieve data using PostgreSQL query source

    Alternatively, you may proceed with configuring query source. It is useful in the case when records count supposed to be retrieved are more than 200,000.

    postgre-query

    So the chart configuration may look like this.

    postrge-chart-query

Using GitHub App

Github

  • Setup account

    Start with creating a new report, select GitHub app and paste your personal GitHub token. You can generate it here if you don't have one.

    token

    Create an account with your personal GitHub Token.

    github account

  • Select a chart from predefined templates or start creating from scratch

    We have added several templates for GitHub app, so you can select one or create the chart from scratch. There are two sources available — weekly contributions and pull requests.

    templates

    Select repositories to visualize by your profile or for your organization.

    confiture-github-r

     

  • Explore GitHub data visually by changing chart settings

    explore

Let us know about any questions or comments.

 

You can subscribe to our monthly newsletter here:

Thank you!

Сheck out latest blog posts: