Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a several tables with date fields that link together by ID:
Table 1:
[ID]
[A-Date]
[A-Count]
Table 2:
[ID]
[B-Date]
[B-Count]
When I make selections on date fields separately, it works fine.
A-Date = 2014 returns A-Count or
B-Date = 2014 returns B-Count
But if I make selections on multiple date fields, i.e.
A-Date = 2014 and B-Date = 2014
it only shows me a subset of A-Count and B-Count for records that have the same ID
How would I approach this issue if it is necessary to keep the ID link? Is the best solution to use set analysis to ignore field selections? Thanks!
-Jason
Hey Jason,
My stab at it is to use an expression, (Chart - Straight Table) with ID as your dimension or what ever you may use
=count({<A-Date=>}[B-Count])
- what this does is Count, [B-Count] based on selection and ignore [A-Date]
and vice versa for [A-Count].
Hope this is something you're looking for
please post sample data and expected result.
regards
Marco
You could use a set expression like this:
{<[A-Date]=P([A-Date]), [B-Date]>+<[B-Date] = P([B-Date]), [A-Date]>}
(Selected value(s) of A-Date ignoring selection on B-Date, unioned with selected value(s) of B-Date ignoring selection on A-Date.
It could even be a simple as
{<[A-Date]>+<[B-Date]>}
A union of selections (including B-Date) ignoring A-Date selections and selections (including A-Date) ignoring B-Date...