Building Excel Dashboard in Open Calc or Google Sheets

Users
1

Is it possible to build a dashboard in Open Calc or Google Sheets?

I a working with a health system that cannot afford to provide Microsoft
Excel for all the people who are implicate in data summary/analysis so I
would like to build it in a free software.

Thanks,
Sarah

2

Hey Sarah,

The analytics side of this should be possible in other tools to the extent
that they can make the dashboards for you.

I don't know offhand whether it is possible to automatically link something
to a data source in those other tools the way you can in Excel, however if
it's not you could definitely do it with a bit of programming/scripting
using APIs and the data export tool
https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool.
Not sure if you or anyone on your team has capability. The fallback would
be to just copy the data in manually from a csv.

Cory

ยทยทยท On Tue, May 5, 2015 at 6:41 PM, Sarah Mollenkopf wrote:

Is it possible to build a dashboard in Open Calc or Google Sheets?

I a working with a health system that cannot afford to provide Microsoft
Excel for all the people who are implicate in data summary/analysis so I
would like to build it in a free software.

Thanks,
Sarah

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.