Create a dataset by navigating to the Analytics Explorer, specifying a title and description, selecting metrics and fields, applying filters, and configuring additional settings.

1. Navigate to Analytics > Explorer > Datasets , and click NEW DATASET on the top right corner of the page. A new page for creating a new dataset opens.
2. In the name field, specify a title and description for your dataset to help everyone understand what data is included in the dataset.
3. In the Metrics section, select a metric to include in your dataset, and specify the timeframe for data capture. Metrics quantify important aspects of your subscription business. They are automatically pre-computed by Zuora Analytics on the time interval that you configure. If you plan to use this dataset in time series cards, you must select a metric. Otherwise, the time series card will not work. If you plan to use the dataset only in table cards, you do not have to select a metric. For currency-connected metrics such as Gross MRR or Gross MRR changes, you need to select the currency for the metric. You can use the transaction currency or convert it to other currencies. For details about how metrics currencies are converted, see Zuora Analytics limits and currency conversion . Some metrics are non-summable. They cannot be calculated by summing up their constituent metrics. In the drop-down list of metrics, non-summable metrics are below NON-SUMMABLE METRICS . For details about non-summable metrics, see Non-summable metrics .
4. In the Fields section, select the fields to include in your dataset. Datasets will automatically determine how to join fields together and the lowest level of data detail based on the combination of fields that you select. If you select a non-summable metric in step 3, do not select any data fields in this step. Otherwise, the dataset will become an export-only dataset and cannot be used in cards. For details about export-only cards, see Export-only datasets . The following dataset can be used in cards, because no data fields are included together with the non-summable metric "Net Retention Rate". The following dataset is an export-only dataset, because seven data fields are included with the non-summable metric "Net Retention Rate". As you choose fields, you will notice that some fields are grayed out. This is because those fields are unrelated to all the fields that have been selected. Some objects have a parenthetical descriptor after the object name, such as ‘Account (Subscription Owner)’. Because some Zuora objects have multiple join relationships with other objects, these descriptors are intended to help you select field values with the right join relationships.
5. Use filters to reduce the number of records you include in your dataset. If more than 100,000 rows of records are included in your dataset, the dataset cannot be used in cards. You can only export the dataset and perform data analysis in external tools. After saving your dataset, if you receive a message saying that the dataset is over this limit, you can either use filters to reduce the size of your dataset, or remove a high cardinality field (such as Account Number, Subscription Name, or Rate Plan Charge ID). Analytics is intended to be used to understand key trends in your business through fast, interactive analysis. It’s more important to have the right data records than to have a lot of data records. If you need to pull a great number of records (over 100,000, for example), you can consider using Zuora Reporting.
6. In the Additional Settings section, configure the way that your dataset is sorted. This determines the default sorting configuration for all table cards that are based on the dataset. If your dataset has more than 100,000 rows of data records, the sort order configured here will determine which records will be in the first 100,000 rows and eventually included in the dataset.
7. Click Save to save the edits. Data refreshing starts immediately after the edits are saved. Datasets are refreshed once per day or immediately after edits are made. You can monitor refresh progress in Explorer. Once data refresh completes, the saved changes will become visible to all other Analytics users. Note: Only users with the ‘Manage Analytics’ user permissions have the ability to save edits. If you need additional user permissions for your Zuora user account, contact Zuora admins in your organization.