Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart with a total row. When I execute the =count(distinct(field name)) the total includes the row with the totals. Is there a way to eliminate the total row in the count? Thanks.
Hi,
Because of it you are getting 1 extra count.
Either you can subtract 1 manually from your expression or handle null value dimension in your expression
Regards
Not sure what you mean, but try this:
Sum(Aggr(Count(DISTINCT FieldName), YourChartDimensions))
Thanks, but that did not work. Here is an example. There are 8 invoices but the count = 9.
Is Customer Name and Inv Nbr the only two dimensions in this chart? and when you did this, it did not give you the correct total up-top -> Sum(Aggr(Count(DISTINCT FieldName), [Customer Name], [Inv Nbr]))?
There are 8 dimensions in the table. I used Sum(Aggr(Count(DISTINCT [Invoice Number]), [Invoice Number])) since I'm trying to determine the invoice count.
Try the above expression by adding all dimensions in it and see if it gives you the desired output.
It gave me a count of 20
Hi,
If you have Primary Key in your data model I suggest count the Primary key.
Like ID sort of
Share your sample app and data will see whats the issues is
Hi,
Are you selecting Supress when Value is Null option from dimension tab.
Regards