I have table with available server information with date. I want to identify the missing and added server by comparing two dates.
Expected 2 outputs: If I select 2023-08-28 and 2023-08-14 I should get below output.
Table 1: Missing Server from old date
Table 2: Newly added Server
I could not modify my script. So I would like to do this with expression
I hope some one can help me with this
You can get this adding a metric to the tables, counting the servers that fullfil the condition.
For the newly added (Date is max date)
For the missing (Date is min date)
This will only work if you select only the 2 dates you want to compare.
Attached is an example.
View solution in original post
Thank you @Javizh This worked well.