How to Automate Adding Rows of Analysis for Excel Dashboard Feed Integration

Users
#1

I am trying to integrate an Excel dashboard feed through the CommCare
dashboard feed link. The dashboard already has multiple sheets and many
formulas to process the data entry, which up until now has been entered
manually. My goal is to have an automated system where the data will be
updated automatically through the dashboard feed link, and for analysis of
the data to be automated as well. However, I’m not sure if the analysis can
be automated.

Specifically, the dashboard feed link would add a row of data to the Data
Entry sheet of my dashboard for each survey filled. The analysis is done in
other Excel sheets, and I would need rows in those sheets also to be
automatically updated in order for the dashboard to be automatically
updated also.

I realize this may be more of an Excel question, but is there a way to
ensure that when a new row of data is added to the Data Entry sheet,
corresponding rows of analysis (with built-in formulas) are added to the
analysis sheets?

#2

Hi Benjamin,
Not sure if it is what you want, but you can do row calculations for new
entries automatically:
If you go to the sheet where you get your data from CC, you right click the
data --> external data range --> at the bottom choose to fill down formulas.
If this is selected Excel will automatically add formula on new rows
similar to the formula’s on the row on top.
E.g. I used it before to change a timestamp to data only, so I could group
values per day.

1 Like