# Reporting on data

**URL:** <https://forums.losant.com/t/reporting-on-data/1335>\
**Category:** Help\
**Created:** [December 18, 2018, 11:30am UTC](https://forums.losant.com/t/reporting-on-data/1335 "2018-12-18T11:30:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\
**Post date:** [December 18, 2018, 11:30am UTC](https://forums.losant.com/t/reporting-on-data/1335/1 "2018-12-18T11:30:04Z")

</div>

What are my options if I want to do some reporting on data that lives in either a data table or time series data?  
I need to do some totals and subtotals for day , month and year.

---

<div class="post-metadata">

**Author:** ![Michael\_Kuehl](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/michael_kuehl/32/99_2.png) [@Michael\_Kuehl](https://forums.losant.com/u/Michael_Kuehl)\
**Post date:** [December 18, 2018, 3:09pm UTC](https://forums.losant.com/t/reporting-on-data/1335/2 "2018-12-18T15:09:46Z")

</div>

There are a number of different ways to go about this for [time series data](https://docs.losant.com/devices/state/). You could use any of the following:

- The [Data Explorer](https://docs.losant.com/applications/data-explorer/), where you can set your time range and look at the aggregates tab (or set resolution and aggregations and look at the “All Data” tab).
- The [Gauge Query](https://docs.losant.com/workflows/data/gauge-query/) node, where you can set your start time, duration, and aggregation and get a single value out.
- The [Time Series](https://docs.losant.com/workflows/data/time-series/) node, which would allow you to doing things like daily totals for multiple days at once.
- The [Device State Table](https://docs.losant.com/dashboards/device-state-table/) dashboard block, where you could set up a resolution and aggregation and get a table of data similar to the data explorer.
- The [Data REST API](https://docs.losant.com/rest-api/data/), which would allow you to write custom code and query and extract the exact data you need to do your aggregations.
- For absolute control, you could [export](https://docs.losant.com/devices/overview/#data-export) the data for a device as a CSV, and operate on it.

For doing any sort of aggregation on [data tables](https://docs.losant.com/data-tables/overview/), you will end up needing to do a lot more manual work, because Losant generally doesn’t expect “aggregate-able” data to be stored there. You could potentially do something with the [Custom Chart](https://docs.losant.com/dashboards/custom-chart/) dashboard block, or a complicated workflow that uses the [Get Rows](https://docs.losant.com/workflows/data/table-get-rows/) workflow node where you then aggregate the values yourself in the workflow. You could also always [export](https://docs.losant.com/data-tables/overview/#exporting-a-data-table) the data table and operate on the CSV locally with a tool like Excel.