So you have this: >= 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. and you have this as your requirement: 00:01:00 to 08:00:00 (12AM-8AM) 08:01:00 to 16:00:00 (8AM-4PM) 16:01:00 to 00:00:00 (4PM-12AM) Find the differences, adjust the…

Hi Ram, It's ok to use OTN to post questions that you need help with and people will indeed help you most of the time. However, it's also expected that people learn from what is explained and try to do something on their own without having the others do their work for them. You previously created this topic which I helped…

Hi, Assuming you're using an Oracle database (11g or higher),you can use something like this

Should work with: >= 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. However, consider what I told you first and what Thomas explained in more details. This shouldn't be the way you're doing things. It will be much better to take care of…

Don't really understand your issue. You just want to show 3 ranges right? 12AM-8AM, 8AM-4PM, 4PM-12AM, so why do you need the minutes? If you're worried about how the hours are calculated that will be fine because if you 15:59:59 it will show up as 15 hours and if you have 16:00:00 it will show up as 16 hours. Should do…

Hi, To be honest, you should have that attribute in our database table, it's must better to have it there than calculate this in a report. However, considering what you have you can achieve what you want by implementing a CASE WHEN logic similar to this: CASE WHEN HOUR(CURRENT_TIMESTAMP) BETWEEN 0 AND 8 THEN '12AM-8AM'…

If you're looking to get the last underscore of a specific string than you can use the Locate function like this: LOCATE('_','This_is_a_test_for_OTN' ,-1) This will return you the numeric position of the last underscore in your string.

Hi, You're right, the presentation variable value does get through so I'm not sure why you're not able to make this work. I've built an example following the logic you want to implement and it's working fine. Take a look here and see if you can spot some difference between what I built here and what you have.…

Hi, Not really sure the presentation_variable is going to be picked up in the detailed analysis (it looks like it isn't) but in any case I think I spotted what you're missing. In your detailed report you have a filter for "Work Order Status Category is prompted" but you don't have one for "Supervisor Department is…

If you're editing a chart, go to "Graph properties" -> "Style" (2nd tab) -> "Style and Conditional Formatting" -> "Conditional Formatting" (2nd tab) and then create the conditional formatting you want.

Hi, Why don't you create a conditional formatting for the chart where you have something like: <10 color=red (major); >=10 and <20 color= orange (intermediate); >=20 green (minor) and then just create a new Legend view with those definitions and put next to the chart. Otherwise, if you define colours by the bar positions,…

Christian already told you what can possibly cause this to happen. Putting your query here won't really help us because we don't know your data, therefore we can't really help you. What you have to do is compare both queries and see what extra filters (WHERE clauses) exist in the query fired when running the report as that…

Hi, Yes, you definitely can. The problem you're currently having is that you are putting in the ifnull expression a presentation variable that isn't a date. Your formula should be: IFNULL(Book Date, date '@{BranchDate_DRV}'). That will solve your issue. One more thing that can also be useful regarding your question is what…

Maybe it's because of the late hour but I'm having issues understanding your problem. You have a custom "No Results" message that will be displayed whenever your analysis don't return results. However, you're saying that users don't want to see that message and you create null entries in the database to display instead of…

Hi, The problem you're facing is most likely related with the scope of the dashboard prompts (DP). When you place a DP in a dashboard you can select their scope to either dashboard (default option) or page. If the scope is set to dashboard the values selected in the DPs will be carried to other dashboard pages if the DPs…

Hi Jessica, If I understood you correctly you've created some inline prompts in a report and what you described is the expected behaviour. There is a difference between dashboard prompts and inline prompts and you're most likely looking for the 1st. Look this and you'll get a better understanding:…

@Gianni Ceresa pretty much said it all and that's why I asked where you were using that formula. If you just want to manipulate the display of that column then you'll need to use that formula inside the column formula so all records that match that date will display 0 (or null) and all others will display the date. If you…

Looking at the error it does seem like you have an error on the date '1969-12-12'. Where is that CASE STATEMENT being used? Is it inside a column formula? Can you please post a screenshot of that? Also post a screenshot of the values in column "Agreement Sent Date"."Date"

Hi, You don't really say much that we can help you with. What isn't working? Which error are you getting? Your CASE syntax is correct but I have some doubts that comparison between your date and '1969-12-12' won't throw an error since you aren't comparing a timestamp to a timestamp. Anyway, unless you give more details…

Hi, It will be easier if you just put a couple of screenshot of what you're trying to do. Your description isn't very clear (at least, not for me). Just put some images of your prompt and your report and that way it'll be easier for you to get an answer.