https://community.qlik.com/t5/QlikView/Active-By-Month-Telematics/m-p/1681763#M455839 <P>I'm working though some telematics data and want to be able to work out the total pop of machines counting all machines from the first date they sent data until today.</P><P>Not all machines work every day, which is fine, but I want to show % of machines that worked during a month, vs all the machines that "could" have worked.</P><P>What is the simplest way to do this.&nbsp; I'm assuming I load all data, then reload a separate table with firstdate only and then use this to create a count of all possible machines. Is there a way to do this without multiple loads.</P><P>Machines are identified by a unique serial number.</P> Wed, 04 Mar 2020 16:45:24 GMT dmac1971 2020-03-04T16:45:24Z https://community.qlik.com/t5/QlikView/Active-By-Month-Telematics/m-p/1681763#M455839 <P>I'm working though some telematics data and want to be able to work out the total pop of machines counting all machines from the first date they sent data until today.</P><P>Not all machines work every day, which is fine, but I want to show % of machines that worked during a month, vs all the machines that "could" have worked.</P><P>What is the simplest way to do this.&nbsp; I'm assuming I load all data, then reload a separate table with firstdate only and then use this to create a count of all possible machines. Is there a way to do this without multiple loads.</P><P>Machines are identified by a unique serial number.</P> Wed, 04 Mar 2020 16:45:24 GMT https://community.qlik.com/t5/QlikView/Active-By-Month-Telematics/m-p/1681763#M455839 dmac1971 2020-03-04T16:45:24Z