https://community.qlik.com/t5/App-Development/Aggregation-per-day/m-p/1682865#M51985 <P>can you share the expected output ?</P> Mon, 09 Mar 2020 12:30:32 GMT Taoufiq_Zarra 2020-03-09T12:30:32Z https://community.qlik.com/t5/App-Development/Aggregation-per-day/m-p/1682863#M51984 <P>Hello everybody,</P><P>&nbsp;</P><P>I have the following data:&nbsp;</P><TABLE border="1" width="100%"><TBODY><TR><TD width="25%" height="25px">datetime</TD><TD width="25%" height="25px">date</TD><TD width="25%" height="25px">time</TD><TD width="25%" height="25px">availability</TD></TR><TR><TD width="25%" height="25px">01.01.2020 10:00</TD><TD width="25%" height="25px">01.01.2020</TD><TD width="25%" height="25px">10:00</TD><TD width="25%" height="25px">0.90</TD></TR><TR><TD width="25%" height="25px">01.01.2020 20:00</TD><TD width="25%" height="25px">01.01.2020</TD><TD width="25%" height="25px">20:00</TD><TD width="25%" height="25px">0.70</TD></TR><TR><TD width="25%" height="25px">02.01.2020 10:00</TD><TD width="25%" height="25px">02.01.2020</TD><TD width="25%" height="25px">10:00</TD><TD width="25%" height="25px">0.80</TD></TR><TR><TD width="25%" height="25px">02.01.2020 20:00</TD><TD width="25%" height="25px">02.01.2020</TD><TD width="25%" height="25px">20:00</TD><TD width="25%" height="25px">0.90</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I am trying to create a line chart where the dimension x-axis are the dates and the measurement (y-axis) is the avg(availability). Does anyone now how to aggregate the dates?</P><P>&nbsp;</P><P>Thank you in advance!</P> Sat, 16 Nov 2024 03:02:48 GMT https://community.qlik.com/t5/App-Development/Aggregation-per-day/m-p/1682863#M51984 limu 2024-11-16T03:02:48Z https://community.qlik.com/t5/App-Development/Aggregation-per-day/m-p/1682865#M51985 <P>can you share the expected output ?</P> Mon, 09 Mar 2020 12:30:32 GMT https://community.qlik.com/t5/App-Development/Aggregation-per-day/m-p/1682865#M51985 Taoufiq_Zarra 2020-03-09T12:30:32Z