Forum Discussion
Comparing two filtered text fields in the same table and displaying the differences
Can you elaroate the data a little more, may be share it
Thanks for your reply. I'll try adding more detail. There's a fourth table involved called environment. I have a slicer of it on the report twice. The first slicer (ENV1) affects the Source table, and the second slicer (ENV2) affects the Target table. I'm having trouble getting the difference (from Source and Target) to display in a third column.
(w/ENV1 Filter) (w/ENV2 Filter)
[ENV1] [ENV2] [Source] [Target] [Difference]
-------- -------- --------- --------- -------------
|Dallas| |Chicago| |1111| |0000| |1111|
|2222| |2222|
|3333| |3333|
|4444| |4444|
The EXCEPT function appears to be used table to table, which I don't think applies here. Let me re-describe my use case.
The goal of the report is to display the software versions installed across multiple servers and display the differences. The data set is an single appended table from 16 individual Oracle connections. I have two calculated text columns (named Source and Target) that are both based on the same column (Version). They are both sliced by Environment. I want a third calculated column to display the differences between Target and Source. I'm having trouble with a custom filter seeing the passed in slicer (Environment) selections. Thanks!
Hi there! I have two calculated text visuals based on the same column (table "Source" and table "Target"), both filtered differently. I want a third calculated column to display the differences from Target to Source. The data and what I'd expect looks like this.
[Source] [Target] [Difference]
-------- -------- ------------
|1111| |0000| |1111|
|2222| |2222|
|3333| |3333|
|4444| |4444|
Thanks!