Implement the query

[arulsettu]

Hi i am trying to implement the following query

select pdr_prod_code, count(1),

sum(decode(pdr_status, 'R', 1, 0)) from t_pol_due_for_ren

where trunc(pdr_pol_to_dt) between '01-DEC-2014' and '31-DEC-2014'

group by pdr_prod_code

in line chart. month and year as dimensions

please suggest me something its urgent...

thank you

[arulsettu]

can any one help me on this issue

[arulsettu]

any one plz?

[jagan]

Hi ARul,

Check thsi expression

sum({<PDR_STATUS={'R'}>}PDR_PROD_CODE)/sum({<PDR_STATUS={'R'}>} TOTAL <Year>PDR_PROD_CODE)

Regards,

Jagan.

[arulsettu]

thanks

but result not similar to above image and need to show y axis in percentage

[jagan]

Hi,

Check this file, is this you are expecting?

If not explain with an example.

Regards,

Jagan.

[arulsettu]

hi

what i need is count of pro_status =R/ product code in percentage

[arulsettu]

hi Jagan need exactly like this

status R / Total count

group by product

[jagan]

Hi,

Can you explain with some sample data and your expected output.

Regards,

Jagan.

[arulsettu]

in above qvw fields called

pdr_status in this i have to take pdr_status='R'/Count of pdr_prod_code group by pdr_prod_code

have to show in percentage

[jagan · Accepted solution]

Hi,

PFA file, hope it helps you.

Regards,

Jagan.