In this article, we'll go over different ways of sharing Haystack data.
Haystack allows you to share in 4 ways
Download Images
Export CSV
Using Query Builder
Export Most Used Metrics
Download Images of Any Graphs
Every graph in Haystack has 3 dots next it. You can find Download As Image (.png) button in the dropdown.
Clicking this button will generate an image like below that you can use in your reports.
Export CSV for Any Data Point
All Haystack graphs are clickable.
Clicking any point on the graphs will show a list of individual items on how that point is calculated. You can click on the Download button, which will download all the underlying data for the given date set in CSV format.
Note: By default Haystack scopes weekly. You can use granularity=month or granularity=quarter urls parameters to get the data scope you want.
Ex: https://dash.usehaystack.io/app/speed?granularity=month
Export Any Data Using Query Builder
Query Builder is an extremely powerful tool where you can create any table that can be generated.
To run a query, first select the Measure you'd like to add as a column. Secondly, select the columns (group by) items by selecting it as Dimensions. Lastly, run the query and select table as the visualization option. In the end, you should see a table like below. Copy the table and paste it to Google Sheets to use it for custom reports.
Export Most Used Metrics
Export page allows you to export data higher level metrics such as cycle time, hotfixes etc with a single click in JSON format. You can also group the data by Teams or Repositories.
