If I go further, I would like to check another option. I would like to add average data to the above data (RSUM) (eg the average of the last 30 days at certain times) - is this possible? My time information is written as 08/12/2024 12:00:00.000 AM. I tried the calculation: avg(case when TIME >= (CURRENT_DATE - 30/24) then…

@Ram-Oracle thank you very much for your quick reply!

@RichardChan thanks for the reply. Did you mean here? Because I can't find the section to follow your instructions.

I am using OAS:

It looks like I don't have all the rights granted (I assume our IT does). But for now I'll stick with the existing solution (+h) so thanks for your help.

@Gianni Ceresa it works, I added 6 hours. But it is not clear to me why there are deviations in the new date (4:00/5:00)? —edit: I found out why - because of summer and winter time (+1/+2 GMT) :) @Mostafa Morsy-Oracle I would also like to try this ("Default Time one for Date Calculations") because it is a more elegant way,…

My data source is database. I am not the most in favor of the proposal. If I add 1 hour to all, I save these with 12:00 and "spoil" those with 11:00, am I wrong?

@Joel unfortunately, the cast function also calculates the same (-1 day). Apparently it's a timezone, as @Gianni Ceresa mentioned (GMT +1). Maybe you have another suggestion? I tried with extractday + 1 but it doesn't work, and I also don't think it's the most suitable way, because in the case of a different clock it would…

Thank you both. I'll let you know how I manage

@Gianni Carrero thanks for pointing me to the instructions, they were very helpful @Christian Berg -Oracle yes, I followed the first recommendation and removed the where clause. Now I create parameter, the only thing bothering me is that I have to choose the value below, so here I chose 31.12.2023 when creating the filter,…

How I create a date parameter? I tried adding a column to the table, but it was a dead end. Please guide me

Thanks for your effort. I will try to explain, I don't know if we didn't understand the problem itself, or if I don't understand the answer well because English is not my native language. If I take the example you gave with open: August 12, 2023 and close: May 4, 2024. I want to know if the account was active on December…

I have not given up, but the proposed solution is not adequate, so I am still looking for an alternative solution

I'm sorry, but I don't understand your proposal (You can either deduce that notion of a "Year" according to your SQL definition already - it'll be presented as just another column.) very well.

Thank you very much! I didn't know about this limitation, I changed the query and now it works, thanks!

Yes, I have an error: "Error during query processing (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred." But this query works correctly in sql developer, so I conclude that some minor change is needed Context: I want the balance and average of the last…

But I don't have a "neutral" date in the table. I only have open date and close_date. It should create a "calendar" somehow, but I can't seem to join it with my data. And the parameter function in workbook offer me only current date. If there was a function where I could choose any date, it would be the easiest.

Sorry for the bad answer, I am not quite sure. I am using OAS DV, manual query in data, join diagram. About version - where can I find it?