Confluence Chart Plugin

Jonathan / David - is it possible to change the colours for:

a) the chart border
b) the chart "page" (currently results in a wide grey border around the chart - can I set it to white?)
c) the chanrt background (eg. I might want a very pale yellow)

Hi there Guys

Great marco - am digging the effects. It's amazing what a few graphs can do for upper management morale 

I have two questions.
1) As it stands, the graphs are great. But a really kewl feature would be to allow the graphs to be populated dynamically,  ie: Let the actual values for the graph come from a filter - say from jira. What do you think would be involved / effort required to allow the chart data to by populated dynamically? 

2) I have noticed a few 'INFO' type things coming through in the logs since installing the chart plugin, which i'm not too sure about. Do you know what may be causing it? Is it something i need to worry about ?

14-Nov-2005 19:32:21 uk.ltd.getahead.dwr.util.CommonsLoggingOutput info
INFO: Can't marshall org.jdom.Element because converter 'jdom' is not available. The converter definition may be missing, or required element may be missing from the CLASSPATH

Excellent work though !
Giles

After installing 1.3, the plugin manager still says "1.2"...?

after reading the include comments for importing data, I tried the excel macro(from the Scripting and External Content Macros macros) for generating a chart from data held in an attached Excel spread sheet(chartst.xls). Works on my 2.0.3 installation.

{chart:title=Temperatures in Brisbane|type=bar|width=400|height=350|legend=true}
{excel:file=^chartst.xls}
{chart}

Hi!

I haver a question.

I want to use chartMacro link excel graph.

If I have below date

{chart:title=Naver weekly SLA|type=line|width=500|height=300|legend=true} 
  || || A || B || C ||  
  || Max | 99.1 | 100 | 99.2 | 
  || Min | 94.5 | 96.2 | 97.0 |  

So I want to change y-value from 90% to 100%.
Can I change y-value?

Hi,

The chart plugin works great on my windows box, but does not work on my UNIX box.  I get a NoClassDefFoundError: org/jfree/chart/axis/CategoryAxis, but I verified that I have the jfreechart-1.0.0.jar installed in WEB-INF/lib. I suspect it's because I don't have X11 installed. I've seen this issue with other charting tools not being able to work in a headless environment. Is this a known issue? Any known work-arounds that don't involve installing X11?

When I fetch a page with a Chart using the Remote API and renderContent, the chart-link never works for me. Can anyone verify?

I can supply a python script that calls renderContent if you'd like.

Bob - is it possible using the current macro to get the line chart, but NOT to display the bullets at each point? When you have lots of data points on a small chart, the lines are effectively 4px wide because they're just bullets

Doug, the markup you provided doesn't quite match your example. The data doesn't correspond to your format yyyy.MM.DD. It looks more like yyyy.DD or yyyy.MM. So changing the format to one of these works. It is good you provided the actual data since the sql stuff is hard to reproduce. I would guess you are using MSSQL? I am not familar with the convert function and what it produces so I have to guess - is it providing yyyy.DD (where DD is number of the day in the year - like 189) or does it produce yyyy.MM.dd (where dd is the number of the day in the month)? It is very unlikely it would be yyyy.MM.DD since that is not very meaningful. See the notation guide for all date format meanings. If you still think there is a problem, please open a bug report and we can converse through that. Thanks.

Could you please repost your example, but put it in a {noformat} macro this time - it's hard to tell what the problem might be without being able to see what your parameters are. Thanks.

Hi,
Please find the code again.

{scaffold:IMX}
{table-data:AutomatedTesting}
|| Product / Module Name || Pass || Fail || NA || Total ||
| {text-data:AName} | {number-data:APass} | {number-data:AFail} | {number-data:ANA} | {eval-data:Total}${APass}+${AFail}+${ANA}{eval-data} | 
{table-data}
{scaffold}
{chart:title=Test Matrix |type=line|width=500|height=300|legend=true}
|| || Pass || Fail || NA ||
|| ${AName} | ${APass} | ${AFail}| ${ANA} |
{chart}

Basic Idea is I can add rows in the scaffold at runtime and once I press the apply button in Scaffold the Graph gets updated.

Regards
Amit Khullar

How does one use domainAxisUpperBound when using timeseries charts?

Using Julian dates in domainAxisUpperBound and domainAxisLowerBound does not seem to work. E.g. I have set domainAxisUpperBound=2454009.49999 and the chart displays not values. Any ideas?

Chart plugin - saving chart image as attachment.

Hi There,

After SiteMinder Integration with Confluence for SSO, the image (a pie chart) cannot be loaded.

If we disable Siteminder the image loads.

Would appreciate any input in this regard, we already have '.png'   in 'ignore extension' list in SiteMinder.

Thanks in advance

Regards

Santosh

I have a bar grpah, showing indication of values for each day of a month. The problem is that with 30 data elements the graph cannot be made wide enough to display the full X-axis labels. They are reduced to '...' once there are 20 or more points of data.

I can rotate the graph to be horizontal orinetation which then works, but havinf time sequence going verticle is un-normal and difficult for most to instantly interperate.

What would be fantastic is if the Chart Macro, could allow text/label rotation to print the series labels on the X-axis verticlly below the data instead on only being horizontal.

 Any chance this is a simple fix and might make it into the next version? Or is there a way I can do this already, that just isn't documented or immediatly obvious.

Thanks.

Hi,

is there a way for this macro to create a dual axis chart? If not I think that would be a great feature to have.

Great macro by the way!

Chris

Since our move to 2.3.1 the chart plugin has been failing on us.

When trying to render the simple chart about fishes above it gives us the following error.

Error formatting macro: chart: java.lang.NoClassDefFoundError

Any ideas? 

It would be great if you select a timeSeries and there is no value for a datapoint that the plugin set it to 0 and not interpolate to the newest known value. Maybe as an option?

The problem: If I graph the new registered users by day directly from my users table and there is no user registration for one day then this datapoint won't have 0 users registered.

Is it possible to include the data values on the graph points at all?  I've had this request from one of our users a number of times and kept forgetting to chase it up...

Hi

 I try this code in VM file but this code is not rendering it just show whole code ......... in page

$helper.renderConfluenceMacro(

)

what is exact  code for chart macro in $helper.renderConfluenceMacro (String)?

how can we change  new line in VM file for large String   which is used in    $helper.renderConfluenceMacro (String)?

if we write chart plugin in a single line it is not working

thanks

Neeraj

Is it possible to create a combo chart like the one below?

I have an issue using table-data macro with chart plug-in.

Here is the code I use:
{chart:title=Burn Down Graph|type=line|width=900|height=300|legend=true|displayData=true|dataOrientation=vertical}
{table-data:BURNDOWN}
|| Day || Steady Pace || Actual ||
| {text-data:DAY} | {number-data:PACE} | {number-data:ACTUALREMAINING} |
{table-data}
{chart}
I expect to see 2 lines, but I see just the line for the last one.

I may be missed it in the posts, but I also skip the first row of the data. The first data row appears as a legend.

I use the following data:

and receive the following result:

Can anyone tell me if he/she experienced such a problem and how can I solve it?

Is there the ability to create a 100% Stacked Bar Chart.

If you are using the attachment parameter, use a file name that includes an image extension like .png at least until CONF-9733 gets fixed,

Thanks.  I was using the stacked parameter.  However, I wanted my data results to be treated as a percentage of the total sum across categories.  I actually was able to get it resolved by changing my sql.  I'll put an issue in to have that type of chart added.   

Is it possible to support dashed lines on the line chart? I'm trying to automate some of the charts we've been producing with Excel, and folks are used to seeing target/goal lines as dashed. Perhaps another attribute like "styles" similar to the "colors" attribute? colors=red,green,blue|styles=solid,solid,dashed
If this isn't already logged and you think it is worthwhile, I can log it as a feature request with an example.

Can charts be made into links? So that someone can click "through" the chart to get to a page with more information? I tried a few different syntaxes without success. For example...

[Representative Information|{chart}
|| || Democrat || Republican || Independent ||
|| Mascots | 40 | 40 | 20 |
{chart}]

Is there a macro I can use for this? Or does {chart} have an attribute that would support this?

Hey Bob is there a way to overlay two diffrent graphs. I would like to have 2 completly diffrent graphs, shown toghter?

Hi all! Happy New Year

I am trying to create a scatter graph (at least I a think that is what it is called in the context of this plugin) to display a series of dots on according to thier x and y values.  However when using this macro (see below) all I get is 8 dots on a grid instead of 4 dots that have been arranged according to the xy values. What am I doing wrong? :   Thanks for the help

macro

 {chart:title= title\|type=scatter\|width=800\|height=600\|legend=true \|yLabel=yvalue\| xLabel=xvalue}
|Person1 | 3.23 |  3.27 |
| Person2 |  3.22 |  4.37 |
| Person3 | 1.43 |  2.28 |
| Person4 | 1.29 | 2.08 |
| Person5 | 4.40 | 3.19 |

{chart}

Hi there

I am using the 'dataDisplay' to show the actual data table and I need to add currency ($) symbol to the numbers.

Is this possible...?

Thanks

Joseph

Hi there! Great plugin! I am trying to utilize the ability to not chart 0 values as referred to in CHRT-50, but am not meeting with much success. The simplest version of what I am attempting to chart is:

{chart:title=Burndown\|type=line\|width=500\|height=300\|legend=true\|dataorientation=vertical}
|| || Actual || Optimal ||
| Start 6.7 work | 216 | 216 |
| Sprint 5 | 157 | 180 |
| Sprint 6 | | 144 |
| Sprint 7 | | 108 |
| Sprint 8 | | 72 |
| Sprint 9 | | 36 |
| Sprint 10 | | 0 |
{chart}

resulting in:

I'm also curious if there is any way to get the first datapoint to intersect with the y axis instead of out in the chart, but that is a lesser concern.

Can someone give me some idea what I'm missing? Thanks a bunch.

Is it possible to create a combination chart (i.e. a line-bar chart)?

 I get the following data from a stored sql procedure

and would like to display it in a bar chart, where each scenario is interpreted as a series. Whatever parametrization I tried I didn't succeed to display both series.

I'm trying to plot a time series using a bar chart. The chart displays as I'd like except for the X-axis values. I tries to display all labels, but can not because of limited space. The first graph below displays all the data but no X-axis values, while the second displays the x-axis values, but not the full data set. I tried using the DomainTick parameter, but it did not work.

I used the following code for both tables but limited the data in the second to only 12 months vs. 60 in the first.

{chart:type=bar|title=Monthly Returns| dataOrientation=vertical| columns=1,6|width=1000| colors=#003366}

Hi all,

Is there a way to have graph data entered / maintained using a friendly UI (i.e. not csv) and still retain the versioning capabilities of the wiki?

Eventually I'd like to graph across versions... not sure exactly how to do that either.

Any thoughts???  Let me know.

Thanks,

Baher 

I can not download the latest build. I get a directory listing. what gives?

Hey guys, I'm trying to use the chart macro to graph the resultant table from the Popular macro.  The graph came out ok excep it did not plot the 1st row of data since it thinks it's a header row.  The problem is that the table generated by the popular macro does not have a header row.  as a result, the first row of data in the table gets ignored.  I searched everywhere for a row to either add a header row to the output table from the Popular macro, or to somehow ask Chart macro to ignore checking for header row.  No luck so far.

 thanks!

Ming

Hi Bob,

I am using Chart plugin two versions - one works all fine but the latest version doesnot work it is giving me following error:
Chart macro: Error with chart data
You are attempting to add an observation for the time period April 1992 but the series already contains an observation for that time period. Duplicates are not permitted. Try using the addOrUpdate() method.

I checked the data in the database there are no duplicate for this month. the same code works on another server which has chart plugin version 1.5 . this new server has 1.9 (latest). Please help ..
I am not sure what i did wrong.

{chart:type=timeSeries|dateFormat=MM-yy|timePeriod=Month|title=Production By \\ Month (Red=coco, Green=milk, Blue=Water)|legend=false| width=1100|height=400|dataOrientation=vertical|rangeAxisLowerBound=0|colors=aqua,lime,aqua,aqua,red,aqua,aqua,aqua}
|| Month || COCO ||
{sql:datasource=OracleDS|p1=$API|heading=0|output=wiki}
select to_char(prod_dte,'mm-yy') Month, mnly_coco_qty from MNLY_TOTL_VW where api_nbr = ?{sql}
|| Month || MILK ||
{sql:datasource=OracleDS|p1=$API|heading=0|output=wiki}
select to_char(prod_dte,'mm-yy') Month, mnly_MILK_qty from mms.MNLY_TOTL_VW where api_well_nbr = ?{sql}
|| Month || Water ||
{sql:datasource=OracleDS|p1=$API|heading=0|output=wiki}
select to_char(prod_dte,'mm-yy') Month, mnly_wtr_qty from mms.MNLY_TOTL_VW where api_well_nbr = ?{sql}
{chart}

Thanks
Bharathi

Can I create a pie chart without any pieSectionLabels? I'd like a simple Red/Green/Yellow status indicator, and the labels (in this case) just clutter it up.
!chart65842png.png! 
 

Hi,

I would like to create a bar-chart with two y-axis (similar to that one below).

 
How's it possible to create that? 

Thank's for your help in advance.

 Roland 

I want to create pie-charts based on a query on labels and metadata values. Want to how many pages containing a given list of labels i.e. a {labelcount} macro:

{chart}
    {labelcount:labels,label_1,label_2,label_3}
{chart}

would generate something like:

Something similar for Metadata values:

{chart}
    {metadatacount:Country|parent=Clients}
{chart}

Is this something that could be done with the reporting plugin? I didn't see it as "Macros known to be allowed in the body of the chart macro"... I was thinking writing these macros as they're relatively simple, but I don't want to re-invent the wheel.

Hi,

I have installed chart plugin on one of my spaces. My only problem is, in Bar chart, I am not seeing the datalabels (on top of the bar) getting displayed. I have used the examples "fish sold" and 'Temperatures in Brisbane' still I am not seeing datalabels. Did anyone face this problem ? I have opened an issue and haven't got an update yet.

Any suggestions ?

Thanks in advance

Regards

Siva 

This is a great plugin - thanks.  A question - are there any plans to add support for Bubble charts, as in: 

http://office.microsoft.com/en-us/excel/HA011170761033.aspx

That would be really helpful and I don't see it in docs anywhere.

Hi,

 We started using this plug-in at my workplace and was wondering if there is a way to get showShapes=true to work for time series graphs?

 Thanks

Kevin

is there any way to supply alt text for the chart macro output?

I am using the chart plugin for a line graph with a sql query as the data source. For the most part, everything works as expected. The data on the X axis represents a 24 hour period with data collected in 3 minute intervals. My problem is that the time values are crammed together and not legible. I would like to have all points plotted but only every 10th time value printed on the x axis. How can I do this?

 I am calling the chart macro like this:

Anyone know how to control NULL values in a time series chart?

I have data like

Notice that ColumnA on Jan 7 does not have a value. Unfortunately it draws a line assuming a value of zero. Is there a way for the chart to simply stop drawing the line? I know it can be done by breaking up the data, but that can complicate things and make a longer page display.

Any ideas?

Does anyone know how to change the Yaxis format to display as a % as apposed to a whole number. The plugin seems smart enough to work out that when I enter a value of 150% lets say in the source table, that it will plot it to a value of 1.5 however I want this displayed as 150%. Same as below chart however I don't require the 2 data axis.

Hi,
great Plugin!

I have a table for example with values between 85.000 and 85.100 and want to display them in a high resolution. So i have to set the parameters rangeAxisLowerBound and rangeAxisUpperBound manually to 85.000 and 85.100. The problem is, that i don't really know the lower and upper bounds. Is there any possibility to generate these parameters automatically?

Cheers

Is there a parameter that determines the width of the bars in the bar chart?  In upgrading from 2.7 to 2.10, the bars were narrowed significantly.

Hey guys,

This is an awesome plugin. A couple of functionality questions if I may...

1. Width and colour of graph reporting line: would I be correct in saying that there is currently no abilty to specify the width or colour of the egde of an area graph (not around the entire chart but the actual reporting line along the edge of the area graph).
2. Dynamic colour-shading / traffic light dashboards: Is there an ability automatically shade a graph a particular colour based on the performance of over the entire or a sub-section of the time frame being graphed? I would love to be able to extend the traffic light colouring system onto the charts that report on dynamic data, so that the graph is shaded green if the last 3 months of a 12 month period have consecutive growth of 5% each month or 10% over the entire last quarter.

B

Hey guys,

Got a few more for you:

1. Multiple chart types: is there a way to mix and match similar chart types? Say an area chart with a line chart, so you could, for example, represent a target line on a chart in a discrete and complementary way rather than having it on par with the core data you are trying to present;
2. Multiple opacities: Similar to how you can specify multiple colours, can you specify multiple opacities to align with those colours.

I am trying to get something fancy rolling like this:

There are many more visualization types but the two things that I am interested in are Shneiderman's Treemap and TagCloud.

Of course there is some out-of-box support for tagcloud in Confluence but I can not do things like:

• Tagcloud of only space labels of spaces with a specific label.
• Tagcloud of only page labels of pages in spaces with a specific space label.

I need a chart based on the following data:

X-axis should show be column 1 (grouped) and 2, Y-Axis column 3.

I am smoking my brain, can anyone point me in the right direction?

Hi,

It appears that the parameter "pieSectionExplode" is not working with 3D pie charts.

• pieSectionExplode without 3D pie chart

  {chart:title=Fish Sold|dataOrientation=vertical|pieSectionExplode=Tuna}
  || Fish Type || 2004 || 2005 ||
  || Herring | 9,500 | 8,300 |
  || Salmon | 2,900 | 4,200 |
  || Tuna | 1,500 | 1,500 |
  {chart}
  

  yields

  

• pieSectionExplode with 3D pie chart (Tuna section doesn't explode out of pie chart)

  {chart:title=Fish Sold|dataOrientation=vertical|pieSectionExplode=Tuna|3D=true}
  || Fish Type || 2004 || 2005 ||
  || Herring | 9,500 | 8,300 |
  || Salmon | 2,900 | 4,200 |
  || Tuna | 1,500 | 1,500 |
  {chart}
  

  yields

  

Any idea?

Regards,
Amit Kumar