Chartio in Brief
Overall Satisfaction with Chartio
- Clean data representation. Once built, the charts and dashboards are very pleasing to look at and easy to understand.
- Great customer service. If there is ever something that I realize I need, but the product doesn't have yet, I can contact Chartio directly and they usually implement a solution for my particular need.
- The data transformation steps while writing charts are very useful. You can reorder and rename columns, pivot your data, add extra filters or groups, etc. What is really helpful is that you can preview your data as you're transforming it.
- There is not a last full month date range option. You can still get the range that you need, but the dashboards will have to be manually updated to exclusively display one whole month.
- When building a chart, the area which displays your tables and fields is finite. You can't adjust the size to make it easier to see. They do allow a mouse-over to see the entire name of your table/field, but I would prefer to adjust the width.
- Once you modify a query in the Custom Query tab, there doesn't seem to be a way to go back to using the U.I.
- Crystal Reports
This product is well suited for end users that don't want to get too in depth with reporting. The interface is simple and the default filter options are sufficient for a general report.
Example: Total Sum of Net Sales for all products sold in X State between dates X and X. If the need is for a more complex query, then there is the Custom Query option. This would be something that an administrator would have to police as having users writing their own queries could get really messy really fast.
I suppose the key questions to ask would be:
Do you need a product that will... display all relevant charts/reports in one consistent place? ... be simple for an end user to navigate? ...be web-based and remotely accessed?