Forum Discussion

IBI's avatar
IBI
New Member
2 years ago

Cumulative Multiple Date

Hi all,

 

I need to display in a line chart 2 cumulative lines representing the running total of documents from the table "A" and "B".

Here the expected output. Specifically I am not sure how to manage the dates in X axis (If I use the DATE from Table A the Running Tot of Documents from table B will be a flat line)

 

Any help would be appreciated. Thanks

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi IBI ,

     

    Did vicky_  and VahidDM  response solve your problem? If solved please mark the helpful answer as a solution and he will help more users, if not please point it out.

     

    Best Regards,

    Neeko Tang

  • vicky_'s avatar
    vicky_
    Super User
    2 years ago

    Create a date table, and use that as your x-axis.
    Also - double check that both of your dates in Table A and Table B are actually date type - normally a flat line shouldn't happen even if you join on a column with missing dates.

    • IBI's avatar
      IBI
      New Member
      2 years ago

       Hi vicky_ 

      Yes this makes sense however how can I then include a filter that would enable to filter the information based on the "Datasource" field? If I establish a relationship between the 2 tables using this field it does not work (inactive relationship)

      Thanks

      • VahidDM's avatar
        VahidDM
        Super User
        2 years ago

        Hi IBI 

        Create another dimension table for DATASOURCE and connect that same as Date table and use it to filter tables.

         

        If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

        Appreciate your Kudos!! 

        LinkedIn | Twitter | Blog | YouTube