How to show uncorrected entities.

[kmatveyko]

Hi,

I have a table with columns:

|   ID   |  BUG  |  Fix Version  |  State  | 

Total count of IDs = 1000, BUG - it just a name (string value), Fix Version like 10.1.1.0, 10.1.2.0 ect., and almost States are "fixed" now.

So, I want to choose a Fix Version and then see bugs that are not resolved in this version. 

I think this should be a measure, but I don’t know how to compose it. Please, help me. 

[v-xiaoyan-msft]

Hi @kmatveyko ,

"I want to choose a Fix Version and then see bugs that are not resolved in this version."

I'm not quite sure if I understand your needs accurately. Would you mind telling me a more detailed description of your needs so that I can help you better?

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[kmatveyko]

Ok,  here is it:

So, if I choose Fix Version in a Slicer, I want to see bugs fixed in the next versions.

For example, in Version 10.1.3.0 bugs "BugName #12" - "BugName #18" are not resolved.

@Pragati11 

Please help me find a solution. How to display them?

[Pragati11]

Hi @kmatveyko ,

Can you share you data in a file and share a download link to the file?

You have just shared a screenshot to your data which doesn't help me in trying the query.

Create a csv file with this samole data --> upload it to dropbox or Wetransfer --> then share the downloadable link here.

Thanks,

Pragati

[kmatveyko]

OK, here is a link: https://www.dropbox.com/s/33tr8og5xs93nry/Example1.csv?dl=0

[Pragati11]

Hi @kmatveyko ,

Share some sample data here? Information is not enough to suggest a caclulation here.

Thanks,

Pragati