Skip to main content
Solved

Cardinality Issue

  • July 2, 2024
  • 1 reply
  • 275 views
R
Newly Minted Pigmenteer
Forum|alt.badge.img+3

Hello Team, 

I am facing a challenge with the Cardinality.

 

Situation - 

I have created a metric (Say A)from a transaction list from which I am pulling a target hire date and I am dimentionlized it with 4 dimensions (month, seat, employee and position worker type). Now I am creating another metric where in i am using ISBLANK () funtion. ISBLANK (A). This is giving me cardinality issue.

 

I think the problem is that although my data set only starts from FY 23, since my calander is set from FY19, this is giving TRUE for all the values from the years I do not want as well which I think is resulting in this problem.

I tried to filter by Month.Year but the formula stops at cardinality i think and not filtering the value.

 

Any suggestions ???

Best answer by gablahoz

Hi @Rahul Kumar, I would consider using the ISDEFINED function instead.

ISBLANK(A) would return FALSE when metric A has values, and TRUE when metric A is blank. Whereas, ISDEFINED(A) would return TRUE when metric A has values, and BLANK when metric A is blank.

And for your downstream metrics relying on this boolean, if you were originally intending to use the FILTER function, you would instead switch to EXCLUDE, or vice versa.

 

View original
Did this topic help you find an answer to your question?

G
Seasoned Pigmenteer
Forum|alt.badge.img+6

Hi @Rahul Kumar, I would consider using the ISDEFINED function instead.

ISBLANK(A) would return FALSE when metric A has values, and TRUE when metric A is blank. Whereas, ISDEFINED(A) would return TRUE when metric A has values, and BLANK when metric A is blank.

And for your downstream metrics relying on this boolean, if you were originally intending to use the FILTER function, you would instead switch to EXCLUDE, or vice versa.

 

CDALMAY
Mat
Walid
3 people like this
  • CDALMAY
    CDALMAY
  • Mat
    Mat
  • Walid
    Walid

Reply


Most helpful members this week

Ask your question here!

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings