We want a reasonably secure website optimised for an ipad that can display graphs of customer data when clicked from a CRM.
The CRM permits a call to a website with an identifying field eg [login to view URL]\record = 1234678.
This would bring up a set of charts based on a call for data to the record in question (1234678)
I am not an expert in this area but I presume we could upload the data is some format (MySQL?) and then calls some charts functions. I have attached an example of what it might look like, but note that this is just suggestive. We can refine things when we know better whats possible and the options available.
Also note I do not expect any drill down or "action" a fixed graphic template would be fine, so long as the axes auto scale so large and small customers look sensible on the chart.
For database structure and so on I am open to your suggestion. I can probably get a data feed sorted to suit what works best for the chart app.
Cheap/free software that is easy to use is desired. Note we do use Tableau desktop in other areas so that would be handy if it did the job but its not necessary. I also do not expect analysis to be done, or spreadsheet editting - just a simple set of charts is fine that anyone non-technical can use.