Count(Total<D1> F1) Question

[#1]

Can I use a dimension D1 in the total with out actually using that in the chart? Please advice.

Count(Total<D1> F1).

Thanks

[MK_QSL]

no

The Result you will get is

Count(Total F1)

[Clever_Anjos]

Yes you can

Count(Total<D1> F1) returns total count considering your D1 dimension (I supposing you´re using it as a dimension in your graph)

[#4]

YEAR	ID
2001	A1
2001	A2
2001	A3
2001	A4
2002	A1
2002	A2
2002	A3
2002	A3
2002	A6

How can I count the distinct IDs grouping by year with out actually showing/ selecting the Year field as dimension in the chart. I have other dimensions I will be using on the graph.

Desired result: 8.

Thanks

[maxgro · Accepted solution]

in a textbox?

sum(aggr(Count(DISTINCT ID), YEAR))

[MK_QSL]

COUNT(Distinct ID) This will give you COUNT of ALL Distinct ID

Do the Group By YEAR

Aggr(COUNT(Distinct ID),YEAR)          This will create a Virtual Table Year vs Count(Distinct ID)

Now do SUM(of above Expression) This will give you your desired result..

SUM(Aggr(COUNT(Distinct ID),YEAR))

[#7]

Thanks so much to both Manish and Massimo.