Default dashboards for new installs

[mark-prins]

Would like to have some default dashboards on first install.
The suggestion is to configure a grafana.db which would be bundled with our custom installer and this would have an initial setup.

Suggestions for boards & panels:

Overview

• Date updated (ex Cote d'Ivoire)
• Pending invoices
• Pending purchase orders
• MOS doughnut (ex Liberia)
• Stock value history (ex Liberia)
• Total stock value

Stock

• Months of stock on hand (ex Liberia)
• Stock overview (ex Liberia)
• Stock outs (ex Liberia)
• Expiring Stock (ex MAM)

Sync Statistics

• Sync status by site (ex Cote d'Ivoire)
• Transactions by site over time period (ex Cote d'Ivoire)
• Version and date of last connection (ex Cote d'Ivoire)

[mark-prins]

@craigdrown @CarlosNZ - suggestions for what to include?
I'll make a start as part of #96 - this issue will be open and can be updated whenever. no rush.

[craigdrown]

@mark-prins that list is a good start I think. Thanks.

[CarlosNZ]

Where have you put the ones you've done so far? Should we have a demo dashboard installation that we can collaborate on and then export the JSON to the installer once we're happy with the "package"? Might be able to add some Materialized Views and organise the folder/tagging structure a bit too?

[mark-prins]

Where have you put the ones you've done so far?

I've put them in the grafana.db that's in /release/data. Maybe a document on the wiki would be sensible? Listing and explaining each one.

Should we have a demo dashboard installation that we can collaborate on and then export the JSON to the installer once we're happy with the "package"?

Yes! The idea was to use demo-board and that has the original defaults. It now needs updating...

Might be able to add some Materialized Views and organise the folder/tagging structure a bit too?

Yes, that'd be awesome!
On the demo site, I also wanted some kind of data generation or updating - so that there'd always be up to date, interesting data to look at. Haven't quite got to that yet.

[CarlosNZ]

I've put them in the grafana.db that's in /release/data. Maybe a document on the wiki would be sensible? Listing and explaining each one.

Sure, I can do that.

Yes! The idea was to use demo-board and that has the original defaults. It now needs updating...

Yes, will do.

On the demo site, I also wanted some kind of data generation or updating - so that there'd always be up to date, interesting data to look at. Haven't quite got to that yet.

Yeah, was wondering about that. Are the "Names" the only sensitive data? Like, could you take a client data file and somehow map all the names and their details to a fictional source, would that be enough? I guess also some of the categories and organisations, too. I guess once we had a list of the fields that need to be "protected", it'd be quite straightforward to write a script to replace actual values with fictional equivalents. Sounds like a fun little job.

[mark-prins]

Are the "Names" the only sensitive data?

I think so, yes. I wondered if it was possible to just update the dates of transactions - there's already a dataset in place, with store and site names changed. Either way would be good - just something to keep the dashboard looking good!