listView function to create bar chart

[ritumishra01]

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

[ajaykakkar93]

Hi,
Instead of ValueList() i suggest using inline table ,
Can you provide a sample data

[ritumishra01]

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