Use case

Exporting a list of Excel files by the repetitions of the embedded VBA scripts

  1. Open the Excel Files dashboard.
  2. Apply any required filters to the visualizations.
  3. Export the data to a .CSV file.
    1. Click the ellipsis in the upper right of a visualization.
    2. Click Explore underlying data from the pop-up menu.
    3. Hover your mouse over the data list panel, then click the ellipsis in the upper right corner of the panel.
    4. Select Export data from the OPTIONS menu. A notification appears showing the request has been queued. When the file is ready, another notification appears providing a download link for the file. You can also see the data by clicking the Exported Data icon on the side panel.
  4. Open the .CSV file in Excel.

    Note the E column called resource.uniqueId. This column provide unique ID for the VBA script embedded in the file. Two files that share the same resource.uniqueId - share the same VBA script.

    Use the resource.uniqueId column and the excel COUNTIF function to generate new column.

  5. Add a new column with the title Rank.
  6. Insert the formula =COUNTIF($E$2:$E$<last-row-index>,E2).
  7. Replace <last-row-index> with the index of the last row of the data in the exported data csv. The value will be the number of occurrences of the embedded script of file from row 2.
  8. Copy the same formula over the range F2:F<last-row-index>.
  9. Sort the Rank column.
Parent topic: Exporting raw data