I`m setting up dashboards which will be cascading with roll ups to the executive level. These are operations related data and not project related.
In setting up the sheets I had looked at some of the templates and seen that very often they are set up with the dates of the entries running along the top of the sheet heading each column vs having them as the row level attribute going along the left side down. This seems to be a relic of project management view of things.
So the question begs which is the best setup?
I'm leaning toward having the dates in one column on the left and the actual KPI's as column headers for the following reasons;
1) Column headers are what smartsheet uses to identify things when working between columns. This isn't done with rows.
2) If using forms to add data it is done in rows not columns. Forms add data either to the top or bottom row. A production type KPI is normally date based.
3) There are many more rows available than columns and for KPI's there are generally more data by dates than actual KPI's.
Any thoughts on the topic would be appreciated.