Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

Recognition

  • Give kudos
  • My kudos

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confluence chart with MySQL

Folks,

I need to display a simple graph with Time on X axis and some values on Y axis and the values are being fetched from the SQL Database. I see that the values are being fetched.

I have a Chart Macro and underneath it I have two SQL statements wrapped under two SQL Macros (I followed Insert=>SQL Macro..) as defined below.

select date,bootupTime from CLOUD where ServiceProvider='PQR';

select date,bootupTime from CLOUD where ServiceProvider='TBS';

What I am expecting is that I need to plot the date (common between the two tables) on the X axis and the values from the columns from the two different tables on the Y axis . I am expecting to see two graph lines on the chart , one for one SQL statement and another for the other, but I am getting only one line being plotted. I am using a line chart.

What is the best way to accomplish this?

Appreciate any help.

ramakris@gmail.com

1 answer

You need different column names. Use something like:

select date, bootupTime as "Boot PQR" from ...
select date, bootupTime as "Boot TBS" from ...

Bob,

I tried that and it is still the same but still the same. I have the screen shot for you. Wondering if I can still use the "line" instead of the time series? Any help will be appreciated.

Line chart is fine, I have an example here that works fine. Use the chart macro parameter to show the data after the chart. Attach the screen shot of the chart and data. Just to be sure, what version of Confluence and chart plugin are you using?

Bob,

I think I figured it out and managed to get it nearly working as I desired to get. Thanks a lot for your help and I really appreciate it.

Regards,

RamaK

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

Share your Confluence Cloud experience for a chance to win $500!

Take our 5-minute survey to win a $500 Visa gift card! Are you currently using Confluence Cloud? We want to hear from you! Fill out this quick survey about your Confluence Cloud experience so we ...

161 views 1 8
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you