Access Pass Reset Date

[jheasley]

I am using the following Master Dimension (created in the license monitor) to determine when my Login Access passes will reset.  can anyone (particularly with @Qlik) verify that this is a valid method?

Login Access Pass ID =

aggr(Only({<Command = {'License user access'},[Access Type]={'Login Access'}>}UsageId), UsageId))

Recovery Date =

Date([Date]+29)

Recovery Count =

Count( Distinct aggr(Only({<Command = {'License user access'},[Access Type]={'Login Access'}>}UsageId), UsageId)))

whether or not my method is correct, why isn't this type of metric part of the current license monitoring application?

[Levi_Turner]

In principle this approach seems right.

Another reference point: https://www.youtube.com/watch?v=Ua1ylwVIxes

twa‌ : Thoughts on integrating this into the default app?

[jheasley]

if you're asking if I would mind if you integrated this - i would not mind at all. plus it would have the added benefit of being reviewed by experts prior to release!  Thanks for your quick reply, i will watch the video shortly.

[Tyler_Waterfall]

Hi Joe -

Yes you could work it that way.

I played around with it a little last year and tried using Date as the dimension and

num(

                Ceil(

                sum( aggr( rangesum( above( count({$<Date,[Access Type]={'Login Access'}>} distinct UsageId),0,27) ),Date))

        /10

        )

        +sum({1} 0)

,'#,##0')

as the measure, making sure you sort by date.

The flaw here is that any missing dates get skipped and skew the projection looking forward.

I'm not sure why you nest an aggr() in your measure though.

Why not just add 28 days to Date and count({$<[Access Type]={'Login Access'}>} UsageId) ?