Month over Month variant for change in Total # of Assets

[tarangvora]

Hi,

I am working on a dashboard and would like to show a report that displays month over month changes in the Total # of Assets that are billed. Such report should be available with a single click on the month in the KPI Charts or KPI. The report should show the New assets added in current month or old assets that were available in the previous month but are removed in the current month. Will appreciate any help I can get here with scripting this logic.

Thanks,

Tarang Vora

[sidhiq91]

@tarangvora  Can you please provide some sample data and also expected output?

[tarangvora]

Hi,

Is it possible to get on a call. I can explain you better. Really appreciate your reply to my post.

Thank you,

Tarang

[vinieme12]

can you post some dummy data and expected output

[tarangvora]

Hi, I am looking for a month to month variant of showing the existing servers, new and removed servers with a single click on the KPI which will open up in a separate sheet which will be linked to the KPI. Will really appreciate your help with it. Thanks!

[voratarang]

Hi Vineeeth,

I am stuck on an important dashboard and need to display asset count on a month over month basis for new assets added and any assets removed.

Assets that are present in previous month but are removed in current month vice versa. Assets that were not present in previous month but are added in current month.

Will appreciate any help you can provide with it. Can we pls. get on a call? My # 978-905-5980

Thanks,
Tina

[anat]

Flag_Table:

LOAD *,

    if( Previous(ID)=ID and AddMonths(previous(Date),1)=Date,1,0) as Flag_Test

   Resident Date

order by ID, Date;

drop table Date; 

can you give a try....