Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Find missing data in sequency

Hi everyone,  Im trying to find the missing numbers for the Number column below:   Each sequence of numbers has a unique name next to it. AB,AC and AD I need to isolate the missing numbers ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, I created a small sample dataset based on the values you provided for the series 'AB'. I believe the below is doing what you're after:

    One thing to note, this measure will only work if your visual table only has one row per series name (which is what it seemed like you wanted anyway). It can be tweaked to remove filter context then reapply only the filter on series name, let me know if this is needed and I'll take a look. Hope this helps, let me know if you have any issues or further questions.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, I created a small sample dataset based on the values you provided for the series 'AB'. I believe the below is doing what you're after:

One thing to note, this measure will only work if your visual table only has one row per series name (which is what it seemed like you wanted anyway). It can be tweaked to remove filter context then reapply only the filter on series name, let me know if this is needed and I'll take a look. Hope this helps, let me know if you have any issues or further questions.