Search the Community

We just recently moved from Google to Caspio. I'm trying to find a way to recreate the same reporting we used in google and the report was created by an outside source. Right now, we are using a bar chart. I would like to do something similar to our previous reports.

I have a chart and I need some more space between its axis title and the drawing itself. However, I cannot see any option to customise that.

I'm trying to add a percentage symbol in the Y-axis values of my Column Chart DataPage using the Formatting feature. They are displaying as percentage, however, all the values are being changed. I just want to add a percentage symbol and retain the values as is. Can someone help with this?

I have a chart that displays data based on a submission form to filter my data. When a person selects a combination that returns no data, is there a way to hide the charts and instead display text saying "There are no records for this search criteria" instead of just displaying blank charts? Thanks

Hi, I have chosen a combination chart to represent my data in which there are bars that represent the annual sales in dollars and there are lines that represent the count of various fields. However, the color used for the bars is quite bold compared to those of the lines. So how can I lighten the color of bars and bolden the colors used for the lines?

Hello all, I am looking to create a column chart URL HERE that allows a user to click on one of the columns to go to a new page. I based my code below off of this jsfiddle. My goal is to have a user click on one of the columns to drill down to another page based on their selection, so if possible, I would love to also include the record as a parameter in the URL string. I cannot get the code below to work even though it works in js fiddle. If it helps, the graph is set so that there will only be 10 records no matter what. <script src="https://code.highcharts.com/highcharts.js"></script> <script type="text/javascript"> Highcharts.chart('container', { chart: { type: 'column' }, title: { text: 'Click points to go to URL' }, xAxis: { type: 'category' }, plotOptions: { series: { cursor: 'pointer', point: { events: { click: function () { location.href = 'https://en.wikipedia.org/wiki/'; } } } } }, series: [{ data: [{ x: 1, }, { x: 2 }, { x: 3, }] }] });</script>

Is it possible to change the sort order of a Y Axis of a chart (combination, bar etc) where one could use a Title field for display, but use the Date field for sort order? Thanks! Clint

I have a combined chart and report datapage that I use to display a list of jobs and their status. I would like the list and chart to have dynamic colours according to their status. This is quite easily accomplished, and in fact I have already completed it. My issue comes in place with AJAX. I cannot disable AJAX on a combined chart/report datapage, therefore when I do a bulk edit on my report, the chart reverts back to the default colours. I am guessing this is because the chart loads without running the javascript in the datapage. Is there a way to execute javascript in a datapage not only on load, but also on an AJAX call? Thanks, Josh EDIT: I just realized that it's not because of the combined chart/report that I cannot turn off AJAX, but it is because of the grid edit.

X-axis values on my chart are repeating themselves. In the attached example, I have four courses, all of which are either 3 or 4 credit hour courses. I'd like to have values 1, 2, 3, 4 but instead I'm seeing each number multiple times. I should note that I am formatting the X-axis values to be number type, with a comma. I've experimented with taking away any formatting for the X-axis value but then I get decimal numbers (see attachment). Is there a way to just have a 1, 2, 3 and 4 in this example?

Hello, I want to call a chart datapage from a report datapage. I am currently doing that successfully. I am embedding the http call in the report datapage footer. No problem there. What I would like to do further is to call this embedded chart app without getting prompted by a 'Search' button but call it with one parameter passed in from the report datapage to the http call of the chart datapage. Is this possible to do? Thanks.

I have a chart that is filtered by a submission page passing virtual parameters. Depending on the parameters, the 'count' may be zero for a certain value. Is there a way to display a count of zero on a bar chart (or any type of chart for that matter)? When the chart automatically adjust to the number of bars displayed it messes up their width, size and color scheme. I want the colors representing the people to stay the same, not change just because a person who is usually represented in the middle of the bar chart has a count of zero for that chart.

How does Caspio Chart a multi series line chart without using 0's for values to match up with the TREND Line when the series is plotting data for dates that haven't occurred yet. Blue is a TREND Line and Red is Actuals where the X-Axis Date hasn't happened yet. See the image attached for details. Thanks.