We use Chartio at my company. If you haven't tried it yet, this product is stellar - almost all of our BI needs are handled directly by stakeholders rather than having to go through an engineer, and their support is very helpful and responsive.
I would consider moving off to something like Quicksight if it supported redis. Some of our BI-related data is stored there, and currently to get at it we have an app that proxies data from there to postgres for Chartio's sake.
It is terrific that your end users are willing to spend the time and effort on building their own BI solutions. In my experience, at least with C-levels, that is not the case at all. C-levels also tend to want the most stuff.
I agree, but I must point out that in some cases the alternative to the "time and effort" involved in the exec playing around with a particular end-user report tool is the time and effort involved in a series of meetings attended by the exec and everyone on the chain between the exec and whoever is actually building the reports.
If "not able to specify a report format to a software service, even with assistance-as-needed from more technical users" disqualified one from executive employment, would any firm actually be hurt by that?
I would consider moving off to something like Quicksight if it supported redis. Some of our BI-related data is stored there, and currently to get at it we have an app that proxies data from there to postgres for Chartio's sake.