Log in to AnswerLog in to Follow
2022-02-18 07-31-08
Surya V
15Views
3Comments
How to filter a chart by month wise
Question
Charts

Hi all,

I need to filter my chart/graph by dropdown which consist of months in year?

in my application I 've sales data for daily, and I need to show my data in dashboard as a chart or graph and i need my chart to show monthly wise data in a dropdown.

if anyone know help us through.

0
0
27 May

Hi Surya,

You can filter the data by applying filter condition in Aggregate. Set a input parameter to aggregate and  pass the dropdown selected value as the input of the aggregate and in aggregate you can write the condition  Month(Date) = Inputparameter

Hope this will help.

Best Regards

Devendra

0
0
27 May

Thanks for your timely response and how to link dropdown and chart 

in case if i select june in my dropdown it should only show sales data of june month

0
0
27 May

Hi Surya,

Dorpdown and chart can be linked with the aggregate filter as you select month from dropdown a aggregate refresh will trigger to filter the aggregate with the selected month and the chart will get the data of that particular month 

Kindly check the below working URL.

https://dbaghel.outsystemscloud.com/testChart/Chart

And attached is the working sample.

Best Regards

Devendra



testChart.oml

0
0
27 May
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.