Start exploring by dragging fields
You can start exploring and building charts/ reports by adding fields from the Data pane to the Visualization Settings panel, and click Get Result. As you build a chart, you can add as many fields as necessary, and then move those fields around as you explore your data.
Behind the scene, Holistics will use the metadata from the models and fields to construct a query to be run against your database.
You can also add a new field by clicking on the + Add field area and select the field from the dropdown list. From here you can also add new Business Calculations.
Sometimes, to speed up the process of exploring data, you only want to see a subset of your complete results from your query. You can do this in Holistics by using our Row Limit feature:
Without a set row limit, Holistics supports up to 1,000,000 rows for Data Exploration / Report Creation and 100,000 rows for Data Modeling Preview. When you set a row limit, Holistics will only display up to the number of rows you have set, and let you know about your incomplete results.
- The Row Limit is directly applied on your query.
- Our sort order is important in these situations: Holistics will first applies the limit, and then applies the sort.
This issue will not occur if you define your model measures using Holistics AML
Please be mindful of possibilities that the
fan-out issue may occur while you do data exploration.
When you set relationships between models (many-to-one or one-to-one ), we assume that the fields at the "one" end is already unique.
If the field is not unique, when you drag in fields from those two models, a fan-out will happen. The result set will be a Cartesian product of the two models and may "explode" into millions of rows.
Visit Cannot combine fields due to fan-out issues? to learn more about this error and how to troubleshoot it.