Skip to main content
Version: 16.4

Subject

Subject is the base of data analysis on certain perspective, let's follow this chapter to build a subject.

Structure​

Firstly, define structure of subject. Topics included in connected-space are available here, simply follow the wizard,

  • Step 1, pick topics,

    Pick Topics

  • Step 2, define columns,

    Define Columns

    Column can be from,

    • a topic directly,
    • or a constant value,
    • or computed by functions.

    There are several functions are supported for computation,

    Compute Functions

    Column also can be aggregated by one of count, sum, avg, max and min. If any column is configured as aggregation, dataset should be grouped by other non-aggregation columns.

    tip

    Give a friendly name to each column.

    tip

    Compute functions supported by pipeline also are supported by subject.

  • Step 3, define filters,

    Define Filters

    tip

    Filters are applied for each report in this subject.

  • Step 4, define joins when two or more topics included,

    Define Joins

    tip

    Joins are not needed when only one topic is used in subject.

    Depending on type of join, data searched out contains

    • Intersection of both sides when it is Exactly Match,
    • Left side and right side in intersection when Left Side Prioritized,
    • Right side and left side in intersection when Right Side Prioritized.
  • Finally, view definition dsl,

    Definition DSL

    tip

    Red question mark means something incorrect.

Dataset​

After structure defined, move to dataset page,

Dataset

It is a pagination grid, page switcher is on top-right corner. Check data, make sure they are what you imaged.

info

There is a count limitation for download all data, check Doll for more details.

tip

Columns can be resized, sorted, drag-and-dropped and locked to left.

Reports​

Everything is OK now, let's goto reports page,

Reports

By click header buttons,

  • Back to connected-space,
  • Switch between structure/dataset/reports of current subject,
  • Create new report,
  • Switch to another subject,
  • Delete current one.

And change subject name by click name part in header.