Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have a database with following records:
Document ID, Value
1,A
1,C
2,B
2,C
3,A
3,B
3,C
4,A
4,D
4,E
I have thousands of records of this type, I would like to make selection (and make table or table chart) representation of all documents which include any of the values I select. For example, I would like to make selection of documents which includes values A and values C or D?
So in the case above, in my table I would get all rows from documents 1, 3 and 4.
How would I approach making query or selection like this? (if possible, I am looking at this and my mind draws blank)
dimension
Document ID
Expression
Count({<Value={'A','C','D'}>}Distinct [Document ID])
May be a set analysis like this
{<[Document ID] = P({<Value = {A}>})+P({<Value = {C, D}>})>}
My bad, should be this
{<[Document ID] = P({<Value = {A}>})*P({<Value = {C, D}>})>}