I’m trying to recreate this KPI scorecard format that we currently have in Google Sheets. It’s a monthly view of our global KPIs that we update weekly:
What I love about this format is the simplicity both for filling in and quickly visualizing the overall picture. I’ve already started trying to build something similar in Fibery, but ended up stopping halfway.
Does anyone have suggestions on how to implement this type of view in Fibery? I’m especially interested in:
The best entity structure for tracking weekly KPIs
How to set up the visualization to resemble this spreadsheet layout
Any guidance or examples would be greatly appreciated!
Looking at this, if you’re OK to have rows and columns swapped, so each week is a new row, you could use a table of entities with each of those fields to be imported, entered or calculated via formula.
Then, you can create a report on top of that.
The alternative is to create a Report that loads data from a Google Sheet. But honestly, the transformation of weeks as Columns to weeks at rows will be tricky.
Ah the good old Tabular vs Database Data conundrum
In short, you can’t have the same visual expression and be able to edit the data at the same time.
You can accomplish the overall goal of this spreadsheet by refactoring it or by recreating the sheet exactly in Fibery with, arguably, bad data architecture but good user experience.
Said another way:
You can create a metrics database with a relation to the datapoint database. The metric database should rollup the values per week in their own column, track the status, owner, group and notes. The datapoint database should have a row per date period and a value.
When you create the table you can’t edit the values directly.
OR
Metrics are rows, and all columns are as exactly the same columns as your spreadsheet. Easy to edit and use in views. Harder to work with in Reports.
