Hi all,
In a chart how do I have multiple lines given a multiple selection performed on a lookup field?
As an example I attach two print screens that highlight the discrepancy between the results, In the chart I expect to see two lines instead of one in reference to the resource that is the values selected in the lookup (see file attachement).
Thanks
GM
Hi Gayathri,
I send the query.
select
@select:dim:user_def:implied:rat:ra.id:raid@,
@select:dim_prop:user_def:implied:rat:r.id:id@,
@select:dim_prop:user_def:implied:rat:r.full_name:name@,
@select:dim_prop:user_def:implied:rat:omn_year:year_c@,
@select:dim_prop:user_def:implied:rat:case omn_year_exp
when 'omn_10' then '> 10'
when 'omn_0_2' then 'da 0 a < 2'
when 'omn_2_5' then 'da 2 a < 5'
when 'omn_5_7' then 'da 5 a < 7'
when 'omn_7_10' then 'da 7 a =< 10'
end:year_exp@,
@select:dim_prop:user_def:implied:rat:substring (omn_year,5,4):year@,
@select:dim_prop:user_def:implied:rat:substring (omn_ab_act,5,2):abitoact@,
@select:dim_prop:user_def:implied:rat:substring (omn_ab_an,5,2):omnaban@,
@select:dim_prop:user_def:implied:rat:substring (omn_ab_int,5,2):omnabint@,
@select:dim_prop:user_def:implied:rat:substring (omn_ab_int_opp,5,2):omnabintopp@,
@select:dim_prop:user_def:implied:rat:substring (omn_an_deb,5,2):omnandeb@,
@select:dim_prop:user_def:implied:rat:substring (omn_coll,5,2):omncoll@,
@select:dim_prop:user_def:implied:rat:substring (omn_inter,5,2):omninter@,
@select:dim_prop:user_def:implied:rat:substring (omn_lea_new,5,2):omnleanew@,
@select:dim_prop:user_def:implied:rat:substring (omn_reliab,5,2):omnreliab@,
@select:dim_prop:user_def:implied:rat:substring (omn_resp,5,2):omnresp@,
@select:dim_prop:user_def:implied:rat:substring (omn_skills_Ac,5,2):omnskillsAc@,
@select:dim_prop:user_def:implied:rat:substring (omn_wit_sk,5,2):omnwitsk@,
@select:dim_prop:user_def:implied:rat:omn_av_rating:omnavrating@
from
niku.ODF_CA_OMN_RATING ra
join niku.SRM_RESOURCES r on r.id = ODF_PARENT_ID and r.is_active = 1
where
@filter@
and @WHERE:PARAM:USER_DEF:INTEGER:r.id:p_risorse@
and @WHERE:PARAM:USER_DEF:STRING:omn_year:p_year@
I waiting for your answer.
Thanks
Gianmarco
Hi Gianmarco. just as a sample xog in the attached xog file. It's a sample portlet (testg) with its query.
Stefano
Gianmarco, I am assuming the query you posted is the one for the grid portlet. For the graph portlet query you will need to have one dimension (rat) for resources and one dimension (yr) for year. The rating will be a metric. Should be somewhat like this -
select
@select:dim:user_def:implied:rat:r.id:id@,
@select:dim_prop:user_def:implied:rat:r.full_name:name@,
@select:dim:user_def:implied:yr:omn_year:year_c@,
@select:dim_prop:user_def:implied:yr:substring (omn_year,5,4):year@,
@SELECT:METRIC:USER_DEF:IMPLIED:omn_av_rating:omnavrating@
from
niku.ODF_CA_OMN_RATING ra
join niku.SRM_RESOURCES r on r.id = ODF_PARENT_ID and r.is_active = 1
where
@filter@
and @WHERE:PARAM:USER_DEF:INTEGER:r.id:p_risorse@
and @WHERE:PARAM:USER_DEF:STRING:omn_year:p_year@
Hi Gayathri,
thanks for your help but I still can not get what I want. My goal is a row for each resource.
Hi Gayathri and Stefano,
I resolved.
Thank you
Gianmarco
@Gianmarco can you post the query for the graph portlet? The query must be a two dimensional one with one dimension getting the resources information and the other getting the years in this case.