I am building a dashboard to show numbers of job starts, this is currently built from a Data extract that I replace each week.
I have been asked to add to the dashboard the number of new job starts that have been uploaded to the system in the past week and am struggling to do this.
I cannot use the number of jobs with a start date in the last week as these are sometimes added to the system retrospectively.
I was hoping to either store the number from last week, or count the number of new records in the extract.
Thanks
Hi @Laura Bradbury I would think if you append the data instead of replacing it, it's supposed to show new vs old, respectively the new ones will have appeared only once in your data. If you use attr() function you can see which are the new jobs. Of course, this is not ideal but it's one way to solve it without changing the data source structure.
In the example below, I've wrapped customer name in ATTR(), and what it shows is that for the manufacturer 2D Systems, for the 2019 and 2020, they had 1 customer per year - Daniel and Bill. But for 2022 this manufacturer had more than 1 customer, hence the asterix (*).
