Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to understand how to use the rank function.
I am reporting on license consumption. I have license keys that are valid for a certain length of time. I am looking to rank the create date as more important than the delete date.
My current issue is that I am trying to show consumption over time. But with a line graph there is a peek that is not valid for the counts when a new license is created in the same month that license expires.
My end goal is to not show the license count in the month if its the month it expired.
I would appreciate any help as I am new to this community.
Thank you,
Cassadi
Please attach a sample
Hi,
Maybe, you can put a flag in the expiration date for those licenses and use that flag in the set analysos to not count them.
Or make a condition comparing if( Expiration Date <> MonthYear, count (license) )
Regards,