Rank Dates in a Bar chart

[Anonymous]

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

[sasiparupudi1]

Please attach a sample

[Anonymous]

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,