graphs

[bina8]

I need to create a graph using data from one row. The row contains multiple columns to put on the graph. The data looks like so:
current_month: 80,month_1: 100,month_2: 75, month_3: 70
month_4: 75, month_5: 90

I want to do a bar graph with Month as category and quantity as value. Is there any way to do this? I've looked in the user's guide and didn't find anything.

 

[leyka]

This is a very, very, very bad database design, but there is a decision:

create graph-datawindow from such SQL-SELECT:

  SELECT "months"."month_1" as value , 'month_1' as name
    FROM "months"   
where id =:id
union
  SELECT "months"."month_2" , 'month_2' 
    FROM "months"   
where id =:id
union
  SELECT "months"."month_3"  , 'month_3'
    FROM "months"   
where id =:id
union
  SELECT "months"."month_4"  , 'month_4'
    FROM "months"   
where id =:id
union
  SELECT "months"."month_5"  , 'month_5' 
    FROM "months"   
where id =:id

use "id" or retrieval argument to set the row

 

[leyka]

instead of "id"-column use your key column