Welcome to the Oracle Analytics Community

Home› Satya Surisetti› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Satya Surisetti Rank 2 - Community Beginner

Comments

  • Since your CSSD Date is in date format and as you are comparing the date with string you need to cast your date to string and then compare and it should work as expected. However before applying this logic, check your date format how is it retrieving and then compare your string value matching to your date format ( eg:…
    in Working with Dates in Oracle Data Visualization Cloud Comment by Satya Surisetti Apr 17, 2017 7:00AM
  • Hi, Below are steps to prepare the output the way you want, there might be other alternative ways also. Step 1 : Create 4 calculations, one for each ( Delivered, Shipped, WIP and Total). 1. Delivered % - Delivered /Sum(Delivered + Shipped +WIP) 2. Shipped % - Shipped / Sum(Delivered + Shipped +WIP) 3. WIP % - WIP /…
    in Add Calculation: Percentage in a Pivot table Comment by Satya Surisetti Apr 13, 2017 7:00AM
  • I am having similar issue while loading data through xlsx file. I tried changing the format of data in excel to number and general, still no luck, DVD reads the data type as integer and Treat it as "Attribute". I am assuming if DVD can read the column as data type Integer it should automatically show as measure instead of…
    in DVD not picking up Excel columns as measures by default? Comment by Satya Surisetti Apr 13, 2017 7:00AM