topic Re: listView function to create bar chart in App Development

listView function to create bar chart

ritumishra01 — Fri, 15 Nov 2024 21:30:23 GMT

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

Re: listView function to create bar chart

ajaykakkar93 — Thu, 10 Aug 2023 04:25:40 GMT

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

Re: listView function to create bar chart

ritumishra01 — Thu, 10 Aug 2023 04:59:50 GMT

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