1 Reply Latest reply on Oct 24, 2018 6:47 PM by swaroop.gantela

    Help blending two dates

    matias gripe

      Hi everyone,

       

      I need some help mixing two different dates. I have a start date column, and an end date column. I have two bar charts, one shows de number of different ID's using the start date, and the other using the end date.

       

      I need to create a calculated field that is the ratio between these two quantities and then make a bar chart out of it, but they use different dates (columns) and can't seem to work it out. My real case datais a little more complicated than this, but i created a simple workbook that showcase my problem.

       

      Hope anyone can help me,


      Thanks