Forum Discussion

sleekpeek's avatar
sleekpeek
Regular Visitor
4 years ago

Count Blank Values with Others in Measure

I have the query below. For segment, I need to count 2 values (value 1 and value 2) plus any blank values into the query.   Can I do this?   [i've amended the table and field values below to generi...
Need Help
sleekpeek's avatar
sleekpeek
Regular Visitor
4 years ago

I tried, and get this error

sleekpeek's avatar
sleekpeek
Regular Visitor
4 years ago

when I add in BLANK() the query accepts it, however the values do not change and i'm missing a considerable amount 🙂 I've checked my visual, page and all pages filters and i'm not filtering anywhere to exclude these blanks.

 

when exporting, it looks like this:

The segment field references the field to the left ... should I add something to the segment field instead?

 

any other suggestions guys .. thanks so far

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    sleekpeek  is there any way you can provide a minimum reproducible example of your issue?

    • sleekpeek's avatar
      sleekpeek
      Regular Visitor
      4 years ago

      thanks for the suggestion, I don't think I can.  My issue stems from the owner_segment field not (a) having the values we need for a high level segment and (b) not being mandatory hence the blank fields.  The regional segment is a data group field bucketing lots of values from the owner_segment field into 3 values only, however you cannot bucket "blank" I believe.  I think my solution is to ensure that sales ops complete that field on all sales user profiles in the data source.