Skip to main content

I have a table with 2 metrics: M1 and M2. Both metrics M1 and M2 are having the Customer dimensionality.

Created a data action to export the table,
Action on click: Trigger Export
Selected the table/block name and then 2 metrics in the dialog box in ‘Action Widget Settings’, header names is kept as “Display Name”.
Noticed, while getting the export i.e. CSV file in the downloads folder, it contains only those rows which are having values either in M1 or in M2, but I want to see all the customers in the export view even if M1 and M2 both are Blank.

Hi ​@pigment_enthusiast ,

The Pigment export feature will purposely exclude empty rows and columns in order to optimize the export. However, there are a couple of ways you could create an export with the empty rows/columns included:

  1. Create a temporary Metric with a formula that fills empty rows/columns so they’re included in the export. For example, create a metric with a formula like `IF(ISBLANK(M1) AND ISBLANK(M2), 1, 1)`. Add this metric to the table and include it in the export. This ensures all rows are included.
  2. Consider using the Pigment API for exporting data. The API allows more control over the export process, including the ability to include all rows. You can find more info on how to use the Pigment API here.

Let me know if you have any questions about either of the above approaches.

Cheers,
Marty

Reply


Ask your question here!

Terms & ConditionsCookie settings