This page is only visible when you have choosen project on Projects page and is specific for that given project.

Segmenation page enables you to create charts from data in record context using options similiar to SQL


Choosing event

First, you need to choose for which event you will perform segmentation. Events are basically record messages.

Available "SQL" options

  • Group by
  • Analysis (SQL aggregation) type
  • Target property (on which will be performed aggregation)
  • Interval (Groups by given timeframe. E.g you can see results month by month)
  • Filters


Money earned in 7 days (counted as sum of the price for each purchase) example Money earned in 7 days for each product example How much earned each brand each day in 7 day example Average purchase price each hour in 24 hours example