count of dimensional value with if condition against expression measure

qs123 — Sat, 16 Nov 2024 01:13:56 GMT

Hi,

Within the License Monitoring App, I have created a table with one dimension and one measure.

Dimension = User Name
Measure = If user has never logged in, then count number of days since the License was allocated and today's date... Else count the number of days since the User was last logged and Today's date

The expression I use is as this... if([User Access Last Used] ='Never', floor(date(now())) - floor(date([User Access Created])) , floor(date(now())) - floor(date([User Access Last Used])) )

The above expression is giving me expected result in the table. But I want to use a single value in KPI to show total number users who have been inactive since more then 90 days..

so.. how do I count total number of users, which has this measure value > 90 ?

Re: count of dimensional value with if condition against expression measure

forte — Tue, 27 Oct 2020 20:15:18 GMT

Hi @qs123

Just try this, using aggr

sum(

aggr(

if(

if([User Access Last Used] ='Never', floor(date(now())) - floor(date([User Access Created])) , floor(date(now())) - floor(date([User Access Last Used])) )

> 90,1,0)

, [User Name]

)

Hope it helps

Regards

topic Re: count of dimensional value with if condition against expression measure in App Development

count of dimensional value with if condition against expression measure

Re: count of dimensional value with if condition against expression measure