1 Reply Latest reply on Feb 22, 2017 3:40 PM by diego.medrano

    Data blending and roll up calculations

    Mohit Shroff

      I have 4 tables in Oracle and want to join the tables but data extraction took too long so I blended the tables even though they are from the same database. Now I would like to do roll up date calculations. The original data comes in hourly but I want to roll up the calculations to daily, weekly and monthly. When I created a calculated field between measures from 2 different tables, by default it aggregates to sum in the calculated field and doesn't roll up in the viz to daily, weekly and monthly calculations.