Forum Discussion

robertsbm's avatar
robertsbm
Frequent Visitor
8 years ago

Comparing two filtered text fields in the same table and displaying the differences

Hi there! I have two calculated text visuals (Source and Target) based on the same column (Version). They are both sliced differently. I want a third calculated column to display the differences from...
Need Help
ChandeepChhabra's avatar
ChandeepChhabra
Icon for Impactful Individual rankImpactful Individual
8 years ago

Can you elaroate the data a little more, may be share it

  • robertsbm's avatar
    robertsbm
    Frequent Visitor
    8 years ago

    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|

      • robertsbm's avatar
        robertsbm
        Frequent Visitor
        8 years ago

        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!