Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am using below quesry to get bar chart but its not working while i do any selection .
although there is a proper association between table via primary key (being ID)
status = ValueList('Submitted', 'In-Progress', 'Under-Review')
IF(ValueList('Submitted','In-Progress','Under-Review')='Submitted',
(avg({<idea_mivalue={'Submitted'}>}idea_mi_duration)
+avg({<dmnd_mivalue={'Submitted'}>}dmnd_mi_duration)
+avg({<prj_mivalue={'Submitted'}>}prj_mi_duration))/3,
IF(ValueList('Submitted','In-Progress','Under-Review')='In-Progress',
(avg({<dmnd_mivalue={'In-Progress'}>}dmnd_mi_duration)
+avg({<prj_mivalue={'In-Progress'}>}prj_mi_duration))/2,
IF(ValueList('Submitted','In-Progress','Under-Review')='Under-Review',
(avg({<dmnd_mivalue={'Under-Review'}>}dmnd_mi_duration)
+avg({<prj_mivalue={'Under-Review'}>}prj_mi_duration))/2)))
how can i link this with data in table any suggestions much appreciated
Hey ,Thanks for your response.
we have three tables :-idea_metri, demand_metric and project metric and it is associated with another three table(idea,demand,project) via idea_number demand_number and project_number.
but to calculate the status and duration we are using these tables and idea_mi_value and idea_mi_duration in idea metri and other dmnd_mi_value and dmnd_mi_duration and prj_mi_value and prj_mi_duration is used for calculating status and Average time duration
as already mentioned it should change with other selection as we have tables associated
Any help here is much appreciated. need it asap