https://community.qlik.com/t5/QlikView/Chart-representation/m-p/1625874#M734397 maybe there is some hidden compelxity. but follow below steps<BR />add Month , Department as dimension and expression avg(TAT) Thu, 19 Sep 2019 15:49:52 GMT dplr-rn 2019-09-19T15:49:52Z https://community.qlik.com/t5/QlikView/Chart-representation/m-p/1625766#M734396 <P>Hi Guys, I'm new to this qlikview and have a doubt in the graphical representation.</P><P>I need to show a trend chart showing the RAG status of average of the TAT for each Department on a monthly basis</P><P>I have below data with me.</P><P>TAT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Department &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Month</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Chart-representation/m-p/1625766#M734396 tenyeapen 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Chart-representation/m-p/1625874#M734397 maybe there is some hidden compelxity. but follow below steps<BR />add Month , Department as dimension and expression avg(TAT) Thu, 19 Sep 2019 15:49:52 GMT https://community.qlik.com/t5/QlikView/Chart-representation/m-p/1625874#M734397 dplr-rn 2019-09-19T15:49:52Z