User_CEU9I — Oracle Analytics

Welcome to the Oracle Analytics Community

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

User_CEU9I Rank 5 - Community Champion

Comments

  • HI Pedro, This question is with regard to my previous thread, which you have mentioned in your thread.. that is you have given solution for hours range like below. >= 0 and < 8 falls in the range 12AM to 8AM >= 8 and < 16 falls in the range 8AM to 4PM >= 16 and <=23 falls in the range 4PM to 12AM. Here i am having a small…
    in How to convert time stamp to hours Comment by User_CEU9I Oct 1, 2016 9:18AM
  • Hi Pedro, Thanks for the help. I understand your suggestions and thomas also. I am using cloud instance in my project and i dont have access to change DB and RPD. This is the limitation in the current project. I have only webcat to work on. I am forced to do everything at the report level. Regards, Shubham.
    in How to convert date to hours range Comment by User_CEU9I Sep 23, 2016 12:24PM
  • Hi Pedro, You are right, i want the ranges mentioned in my first thread only. Please let me know how to make 4:07:00 PM fall under 4 PM - 12 AM. instead of 8 AM- 4 PM. Regards, Ram
    in How to convert date to hours range Comment by User_CEU9I Sep 23, 2016 11:51AM
  • Hi Pedro, Thanks for the reply. I am able to get the result but it is not counting minutes. Please see the below screen shot. For the first row, it should come 4 PM - 12 AM. Third row also it should be 4 PM- 12 AM. How to consider minutes also in the formula. regards, ram.
    in How to convert date to hours range Comment by User_CEU9I Sep 23, 2016 10:44AM
  • Hi, My requirement is like this, I have dashboard prompt with year and month columns. I have two reports one is yearly report and another is month report. Both reports should be displayed. I am clear on yearly report ..here i have year column in the report and made this column as Is Prompted so my report will filter based…
    in weekly data report Comment by User_CEU9I Aug 25, 2016 11:58AM
  • Hi, I have requirement like this... I have dashboard prompt with year (defaulted current year) and month (defaulted current month) as filters. I have two reports. 1. yearly data (based on year filter). 2. weekly data (based on month filter) - report shown as above - how to achieve this? Please let me know any further…
    in weekly data report Comment by User_CEU9I Aug 25, 2016 10:43AM
  • Hi cesar, The output should be displayed below (next row) NOT in next column. How to get value in the next row. Regards Chandra kanth.
    in How to get delta value from a measure column Comment by User_CEU9I Jul 5, 2016 4:54AM