chart question

Question

Hi, i have a table and chart produced like this below.

Currently its showing one column for one component. Instead i need a graph with 2 columns for each component showing the current and past month values. i am using the stacked bar graph.  i need something like a grouped stacked bar. Is it possible please? thanks.

Stiltsoft support · Answer

Yes, you are correct - just to show the gap :)

Nags Subramanian · Answer

Hi Thanks for the reply. will definitely try it out. why do you have to do this?

SELECT T1.'Project', 0 as 'Done' FROM T1 GROUP BY T1.'Project')
ORDER BY 'Project'

is this to show a gap between bars in the graph for each project, if so, very clever :)

Marc -Devoteam- · Answer

Hi @Stiltsoft support

Thanks for answering, I was already suspecting it to be table and charts option.