chart question

[Nags Subramanian]

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]

Hi @Nags Subramanian ,

It is not possible directly but we can suggest trying the following workaround:

SELECT 'Project' + " - " + COALESCE('Month', "") AS 'Project/Month', * FROM
(SELECT * FROM T1
UNION ALL CORRESPONDING
SELECT T1.'Project', 0 as 'Done' FROM T1 GROUP BY T1.'Project')
ORDER BY 'Project'

Now we can create smth similar to your needs:

Hope it helps.

[Marc - Devoteam]

Hi @Stiltsoft support 

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

[Nags Subramanian]

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 :)

[Stiltsoft support]

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

[Marc - Devoteam]

Hi @Nags Subramanian 

what marketplace app are you using and what is your configuration on the page and the chart look like?

[Nags Subramanian]

Odyssey and Wiki confluence page. i used  some pivot and table transofrmation macros to build the table. and then using the chart from table macro and used a stacked column chart.  hope fully i have answered your question.