Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Platform | OI_Systeminfo.virtual | Inventory | Date | count |
AI | Virtual | CCMF | 11/25/2017 | 51 |
AI | Virtual | CCMF | 11/26/2017 | 51 |
AI | Virtual | CCMF | 11/27/2017 | 52 |
AI | Virtual | CCMF | 11/28/2017 | 52 |
AI | Virtual | CCMF | 11/29/2017 | 52 |
AI | Virtual | CCMF | 11/30/2017 | 52 |
AI | Virtual | CCMF | 12/1/2017 | 52 |
AI | Virtual | CCMF | 12/2/2017 | 52 |
AI | Virtual | CCMF | 12/3/2017 | 52 |
This series getting increase as per the new date .
I have tried a expression /Set analysis ,
=sum({<Date={Today(),-1}>},count))
which is not working .Please help
I need sum of count for all type of platform .
Let me know if you need any more details
just replace the and with ,
sum({<Date={"$(=Max(Date))"},Info={'Virtual'} ,Inventory={'DDM'}>}count)
Hi,
Sum({<Date={"$(=max(Date))"}>} Count) -
Sum({<Date={"$(=date(max(Date)-1,'MM/DD/YYYY'))"}>} Count) is fine but it will not cover all situation. For Example If it is not a working day before a day from last date, then calculation will be wrong.
Sum({<Date={"$(=max(Date))"}>} Count) -
Sum({<Date={"$(=max(Date,2))"}>} Count) will be much better approach I guess.
Done ..Thank You very much