Actualoutput.bmp Expectedoutput.bmp
Openerp 7 Graph view i want to shows the output In X-axis Month Y-axis No of Count (Ex: Procedure Performed count)
The below Query is used:-
select
row_number() over () as id,
pm.name as procedure_performed,
count(pm.name) as count_performed,
to_char(invoice.procedure_date, 'MM') as month
from patientprocedure invoice
inner join procedureperformed_rel performed on performed.intake_id = invoice.id
left join proceduretypemaster pm on pm.id = performed.proceduretype_id
group by
pm.name,
to_char(invoice.procedure_date, 'MM')
In the bar chart output shows Count of Procedure Performed values combined with the month and differentiate with colors.
Instead of how to shows the count of Procedure Performed separate based on month?.
please find the Attached screen shot for more clear...
Hi Prakash, did you get any output for this problem.
No not get exact solutions.
did you get near by result???