4 Replies Latest reply: Dec 9, 2016 9:21 AM by Vineeth Pujari RSS

    comparison tables (stock/inflow/outflow)

    Giacinto Abbruzzese

      Hello,

       

      on a monthly basis we get data of our stock properties with id and several further information (columns).

      I'd like to monitor or rather identify stock and new and/or lost properties (inflow/outflow) for each month in the dataeditor by generating scriptwise a filter variable based on the (property)id, so that i can use that filter to identify stock, inflow and outflow properties on the dahsboards.

       

      In other words, i'd like to ask my data the question:

       

      Which properties in table october (timestamp1) are equal to the table november (timestamp2)?

      Which properties in table october (timestamp1) are unequal (inflow/outflow) to table november (timestamp2)?

       

      simplified data structure:

       

      table october

       

      id | name | etc.1 | etc.2 |

      1  |

      2  |

      3  | 

      4  |

       

       

      table november

       

      id | name | etc.1 | etc.2 |

      1  |

      2  |

      3  |

      5  |


      green = stock

      blue   = new property (inflow)


      Thanks in advance

      gino2780