## Manipulating and Exporting Analyses
### Material to cover:
#### 1. Manipulating an analysis
1. Renaming columns
2. Reordering columns
3. Adding columns
Caroline’s tip – add columns from “results” view by double clicking
#### 2. Adding filters/criteria
#### 3. Changing data type in a column
#### 4. Adding in subtotals and grand totals
#### 5. Export data
Excel is most commonly used tool after export, based on last year’s survey, so that’s probably the best focus
1. Export raw data
2. Export formatted report
Notes:
12.5 **minutes**
### Script
part I
1. Create an "analysis"
2. Select Subject Area **Fulfillment**
3. Add some fields:
1. Search:
- Loan Date
- Loan Time
- Circ Desk Code
- In House Loan Indicator
- Loans (Not in house)
4. Save as fulfillment-data
5. Add Filters
Circ Desk Code
in: botcirc
In House Loan Indicator
No
Loan Date
is greater than
Calendar choose date
6. change some column headings, open column properties
7. activate **Custom Headings**
8. edit the **Column Heading** and change *Loans (Not In House)* to *Loan Count*
9. run analysis.
10. Hide In house Loan column. Right click and choose "Exclude"
11. Change date
12. More on this is available in the [knowledge base ](https://knowledge.exlibrisgroup.com/Alma/Product_Documentation/010Alma_Online_Help_(English)/080Analytics/050Common__Analytics_Procedures) In my workflow this is usually where i stop and i do the rest in google sheets. But i'll show you a few things.
13. **Save** again
part II
Alma Version
10. **save as** > - Alma
11. drag Desk Code to the left column
12. click **edit view** on the table of data
13. under **Layout > Table > Columns and Measures** click "Sigma" Symbol (for summation)
14. Add Grand Total
15. Add subtotal for circ desk code. Also see the [Totals/Subtotals](https://knowledge.exlibrisgroup.com/Alma/Knowledge_Articles/Adding_Totals_and_Subtotals_to_Analytics_Report_Tables) knowledge base article for more details
part III
Excel version
"Loan Date"."Loan Date" >= TIMESTAMPADD(SQL_TSI_DAY, -15, CURRENT_DATE)
active requests for inactive patrons?
for more details on specific fields, take a look at the [documentation](https://knowledge.exlibrisgroup.com/Media_Repository/Alma/Analytics_Reused_Content)
```
=countifs(Data!$A:$A, $B3, Data!$B:$B, ">"&E$2, Data!$B:$B, "<="&F$2)
```