Data to filter two diferent dates

Comments

1 comment

  • Avatar
    David Hertzberg

    Hi Luis,

    You can do that, but you might have to update your elasticube model. the idea will be to use one unique "date" field, that has context. The context can be : the type of the row or the nature of the fact table.

    There is a good support article explaining this :

    https://support.sisense.com/hc/en-us/articles/115015450327-Multiple-Dates-in-a-fact-table

    The idea is either to create one line per "date type" or several fact table. So in your case it could be one line per event, and event type would be "product order", "product sold". Or a fact table for orders and a fact table for sale.

    I work with a lot of retailers, and both method works. The first one is a bit more difficult to maintain over time, as you have all measure on each row (not illustrated in the article).

    Good luck !

    Best,

    David

    1
    Comment actions Permalink

Please sign in to leave a comment.