How can I get MS Excel Online metrics to Dear Lucy?

Dear Lucy supports MS Excel Online integration, as long as it is tied to a concept or metric

If you are new to Dear Lucy, you first need to sign-up to proceed with the integration.

In order to add a metric, or even create a full dashboard from a spreadsheet, you first need to define the metric and what type of visualization you would like to see. The steps to successfully add a spreadsheet metric are as follows:

1. Choose what metric(s) you would like to add
2. Choose how you would like the metrics to be displayed on the dashboards
3. From Dear Lucy's templates, fill in your data
4. Share the file with Dear Lucy

1. Choose your metrics

With spreadsheet integrations you can get any metric up on a Dear Lucy dashboard, as long as it is value based.

We recommend that you start off with relatively simple metrics. In most cases the data will be manually updated and the more complex the metric, the more work to update it.

Please note that Dear Lucy dashboards are designed to show you trends and progress. Metrics should therefore preferably be measurable over time and you should ideally also fill in historical values for your metric.

The amount of data is restricted to 10,000 rows by default.

2. Choose how you want to visualize the metric

The most common types of visualizations are listed below, but we also support additional visualizations if none of the examples below will suit your need. 

Bear in mind that you also need to define the time-range of the metric. Would you like the figures to show monthly values, or cumulative this year by month, or weekly?, etc..

Charts and overviews have an underlying table in the drill-down, showing the details of the data comprising the chart or overview. Clicking a table will open up the full table, as only the top rows are shown on the dashboard.

3. Select a MS Excel template to use for your data

Monthly data template

The monthly data template is suitable for data that will show monthly, or e.g. quarterly figures. Data parameters are defined in the different rows and each new month is filled in in a new column. In its simplest form, the spreadsheet contains only one Dimension / Metric column, and then a value for each new month.

Event-based data template

The event-based data template is suitable for data that will include many data inputs every day. For example time reports, transactions or sales activities. Data parameters are defined in different columns and each new event is filled in in a new row. In its simplest form, the table contains one date column, one metrics column and one value column.

Please see attachments at the end of this article to download the templates.

4. Share the file with Dear Lucy

Once you have populated your data into the template, you'll need to integrate it to your dashboards to see your data. The process requires input from Dear Lucy. Please follow the steps below and see the next article in this section to complete the integration:

1. Create a new folder in your OneDrive called e.g. Dear Lucy integration
2. Upload the template with your data, save it as a MS Excel Online document
3. Log in to your dashboard environment and navigate to Settings (the cogwheel in the bottom right corner)
4. Click on the OneDrive for Business, or OneDrive icon and follow the steps to complete the integration.

Please see the following article in this section to complete the integration to MS Excel Online. Depending on your Sharepoint and OneDrive version and plan, and user settings in your company, the integration works differently, to ensure that Dear Lucy can't access more than the designated files.