Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have ID and Companynames. Companyname is dimension and the expression is
Sum(Aggr(Count(Distinct(IF(NOT ISNULL(Companyname), ID))),IssueID))+Sum(Aggr(Count(Distinct(IF(ISNULL(Companyname), ID))),ID))
I already have straight table. I would need to show this information in chart. can anyone suggest me which is the best chart to create this?
Thanks.
Quick question, the 2nd part of your aggr states what to do if is null. Since company name is your dimension and you counting ID when company name is null, is this not rendering your chart redundant since you are unable to drill down into those null values?
Secondly, if IssueID and ID essentially refer to the same thing, just a different key, would a stacked bar chart where you split your expression into two separate expressions be your best bet?
Sorry the expression is Sum(Aggr(Count(Distinct(IF(NOT ISNULL(Companyname), ID))),ID))+Sum(Aggr(Count(Distinct(IF(ISNULL(Cmpanyname), ID))),ID))
Still confused what you are trying to achieve by using company as a dimension but referring to in your expression when that value is null count ID. Would this not populate that same sum across all company values?
Actually I have the below in table
Dimension: Companyname
Expression 1 : Sum(Aggr(Count(Distinct(IF(NOT ISNULL(Companyname), ID))),ID))+Sum(Aggr(Count(Distinct(IF(ISNULL(Cmpanyname), ID))),ID))
Expression 2 : Sum(DISTINCT(Wages))