Calculation in a Text Object

[tmumaw]

Good morning everyone,

I am trying to create a text object which has a description of my number 1 job opening and the number of open requisitions for that job.  I currently have a TOP 10 open requisitions by job.  I'm using a calculated dimension to get it.  Here's the calculation I use for the dimension :  =if(aggr(Rank(Count(Distinct(Requisition)),SF_Job) <= 10, SF_Job)

and the expression is : Count(Distinct(Requistions)).

I would like a text object which show me SF_Job and number of Requisitions for that job.

Thanks

[tresesco · Accepted solution]

Try like:

SF_Job = FirstSortedValue(SF_Job, - Aggr(Count(Distinct(Requistions)), SF_Job))

Number of Requisitions = Max(Aggr(Count(Distinct(Requistions)), SF_Job))

[tmumaw]

The count gives me 0, and the Job gives me nulls

[tmumaw]

=Max(aggr(Count(DISTINCT([Requisition])),[SF_Job]) )  This statement gave me the correct count, just needed a little tuning (Thanks).

[Anil_Babu_Samineni]

Can you please create sample data set and explain your need?

[tmumaw]

Here is some test data