minuz1991

Hello, I'm trying to create a nice animated drilldown such as example below: JSFIDDLE I'm using jaspersoft studio 6.1.0 with HTML5 stackedColumn chart. I couldn't find any tutorials which would explain how to do it. Just by adding series in chart properties wouldn't work.Any help would be appreciated.

Hi, I have a tricky situation. I have SQL query which returns data like so. A B C D 5 3 4 8 The letters are shown as columns and numbers as rows. Is there a way I could extract column names and use them in the html5 pie chart categories? If not, is there a way to manually add categories/series to the pie chart and then link it to the rows? Typically, I would have all column names in a field and then I would add that field to the categories but I can only get individual column names as field. Tried creating arraylist in the expression editor but it didn't seem to work. Any solutions would be greatly appreciated. Thank you.

Hello, I'm trying to calculate cumulative cost in my depth vs days and cost diagram. For example the cost should look something like that : Day_Cost Cumulative_Cost 150$ 150$ 150$ 300$ 200$ 500$ I'm trying to achieve this by using CHART PROPERTIES ->CHART DATA->CONFIGURATION AND MODIFY MY COST MEASURE. In the Cost measure I select calculation as a SUM and value expression as my day_cost, however, I'm not seeing any cumulative values. Is it possible to calculate cumulative value using my method or is it need to be calculated in MySQL query and if so, how would I do it without setting variables to store cumulative value. Here is a screenshot of my results, the red line shows linear progression that I want to achieve using cumulative costs. Any suggestions?