topic Re: Aggr with if or countif in App Development

Aggr with if or countif

Wed, 16 Nov 2016 14:40:51 GMT

Hi,

I am trying to use Aggr with if or countif but no luck. Can anyone please help in understanding this with an example?

Thanks

Shivesh

Re: Aggr with if or countif

sunny_talwar — Wed, 16 Nov 2016 14:59:22 GMT

What are you trying to do? Can you share a sample?

Re: Aggr with if or countif

Chanty4u — Wed, 16 Nov 2016 15:04:22 GMT

just simple example:

=count(if([Unique ID]<>'NULL',[Unique ID]))

Re: Aggr with if or countif

vinieme12 — Wed, 16 Nov 2016 15:47:23 GMT

Example:

Sum(

Aggr(

If(YOURCONDITION , <THEN>,<ELSE>),

,field1,field.....)

)

Re: Aggr with if or countif

Wed, 21 Dec 2016 12:42:01 GMT

Hi everyone,

For example I have a date field in a table called aq_date..Now to calculate "last aq_date", I've created a measure

Max (DATE (aq_date))

Now I want to filter out "Max (DATE (ttr_travel_date)) "which is less than or equal to current date.

I am trying this.....if(Max (DATE (ttr_travel_date)) <= today() which is incorrect.

Please help!

Thanks

Shivesh

Re: Aggr with if or countif

vinieme12 — Wed, 21 Dec 2016 12:53:37 GMT

if(Max (TOTAL DATE (ttr_travel_date)) <= today()

Re: Aggr with if or countif

Wed, 21 Dec 2016 13:32:45 GMT

Thanks Vineeth for such a quick reply! but its returning null values. Let me explain the complete scenario:

I am trying to make an exportable table having various fields. Out of such fields there's one field where I require "Max (DATE (aq_date))" less than or equal to current date.

What should be the dimension/measure I should input?

I tried if(Max (TOTAL DATE (aq_date)) <= today()),aq_date)

Thanks in advance

Re: Aggr with if or countif

vinieme12 — Wed, 21 Dec 2016 13:38:21 GMT

add the criteria to your Expression in Set analysis

example

=sum( {<aq_date = {"<=$(=date(today(),'DateFormatFor_aq_date'))"} >} whatever)

in dimension Try

AGGR(if(Max (TOTAL DATE (aq_date)) <= today()),aq_date),aq_date)

Re: Aggr with if or countif

Wed, 21 Dec 2016 14:57:18 GMT

Thanks a ton Vineeth!!

I removed total in your suggested dimension and it worked.

AGGR(if(Max ( DATE (aq_date)) <= today()),aq_date),aq_date)

Re: Aggr with if or countif

vinieme12 — Wed, 21 Dec 2016 15:11:36 GMT

if you didn't needed TOTAL; then you won't need Max as well

just try

AGGR(if( DATE (aq_date) <= today(),aq_date),aq_date)