Count function in Universe Designer?

[Former Member]

Hi Experts,

I have below table and from there i need to calculate count against two dimensions. I need to calculate count of Meas group by Ver.

Ver	Meas	Count
V1	V1.1	2
	V1.2	2
V2	V2.1	3
	V2.2	3
	V2.3	3
V3	V3.1	1

I tried count(DISTINCT @Select(Mol Objective Kpi Data2\Meas))  but its give below result. 

Ver	Meas	Count
V1	V1.1	1
	V1.2	1
V2	V2.1	1
	V2.2	1
	V2.3	1
V3	V3.1	1

Please let me know which My SQL expression should i get for correct result.

Thanks

[former_member207052 · Accepted solution]

Hi Sudharshan,

1. Create a Derived table with the definition as shown in the below screenshot 1 (also make a join as shown)
2. You can now use the "MeasureCount" variable to get the desired results (screenshot 2)

[Former Member · Accepted solution]

Thanks Narasimhan, Its Amazing.

[Former Member]

On universe create measure object like

count_meas = count(meas)

Now In report level create separate query & drag object

Ver & count_meas (Query1)

I am assuming that in one of the query on webi you are fetching data for

ver , means (Query2)

Now on report level merge Ver object from both the queries & drag

merged Ver object , means (from query2) and count_meas (From query1)

I hope this will help you.

Thanks,

Swapnil

[amitrathi239]

Hi,

I am not very sure how can you do in designer but in webi its easy.

=Count([Meas]) In ([Ver])

Amit

[Former Member]

Hi Amit,

Yeah, but we are developing some dashboards in Design Studio using Universe. So we are trying to implement in Universe.

lets see if others might have some idea on this.

Thanks