Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Thank You @Bhaskar Konar for your kind response, I've defined Balance as a Running Total on Oracle SQL Level. But now the problem is, how do I show the Balance Value of Latest Date of particular Account, I tried using this "Last" but seems disabled: And also tried using formula but errors out: Basically, I'm not intending…
-
Thank You @Ram-Oracle , so at this specific time, I was in the meeting with our NSAW Implementation Team and I am pretty sure that this dataset was never opened as a whole. But FYI, we're working with a Workbook that was using this Dataset: And I suspect that Number of Joins were 7 that got changed to 6. But please note,…
-
Greetings, since the Form requires "Support Identifier" which I am unaware of. I'll circle back with Implementation Team. Thank You ☺
-
Greetings @Ram-Oracle , thank you for the prompt response. This is what I see in URL.
-
I (an Administrator) as well as our Implementation Team aren't able access "System Settings". How could that be resolved? Thank You.
-
Greetings @Ram-Oracle , apologies but this has been figured out, it was Password Expiry that was causing the issue. Thank You So Much for looking into it.
-
Are we talking about this screen? I don't see anything as "Low Service" As asked, in first screenshot, the error pops if I : Click on "Select Columns" OR Enter any Valid SQL Query and hit Run.
-
Thank You @Ram-Oracle for the Prompt Response. Can you please guide me on where to verify the same? I am sorry I wasn't part of the Implementation and might be unaware of the fundamentals.
-
You're right @SteveF-Oracle , as I said I understand how the formula works, and "FAW_DATE" isn't a Measure, basically I'll use Month(FAW_DATE) in a Formula. @Gianni Ceresa , this is the Final Formula: FILTER(MONTH(FAW_DATE) using YEAR = YEAR(@parameter("To Date")(Date '2024-01-01'))) Just to decipher it to you, End User…
-
No it wouldn't give the same error, I tried it earlier and worked fine. FYI for everyone, this was self-resolved by removing the " " (blank space) between semi-colon and 2nd Email. Nonetheless, @Benjamin Arnulf-Oracle, @Harriet Huang-Oracle & @Sumanth V -Oracle thank you so much for your kind suggestions.
-
Sorry @Sumanth V -Oracle , it's not an Email Group, but still when I tried with another 2 Co-workers: Gives out the same error.
-
Yes, it successfully delivers as below (Outlook Snapshot) if I put 1 Addressee in "To " and 1 Addressee in "Cc": Which is why I don't think so if something is wrong in here: Please let me know what could be a possible solution.
-
Thank You @Benjamin Arnulf-Oracle & @Sumanth V -Oracle , I tried separating by comma: And this is what I receive when I hit "Email" button: Not sure where exactly things are falling apart since I can successfully send email with 1 Address in "To" and 1 Address in "Cc" but cannot send when I put 2 Addresses in "To"…
-
@Federico Venturin , you're right. I do not have access rights to this dataset which is why I cannot modify. I replicated this dataset and that did the work. Thank You @Federico Venturin , @Joel and @Mostafa Morsy-Oracle for your inputs.
-
Hey @SteveF-Oracle and @Mostafa Morsy-Oracle, thank you both of you to recommend addition of measures, so I made a test-calculation and added under "Measure", and now I can scroll down till bottom and also able to see headers. @SteveF-Oracle , to answer your question, I'm using "Pivot" rather than "Table" because, I wanted…
-
Sorry, just to clear some air: I am not using Tableau, it's NSAW Workbook (from OAC Console) and above screenshots are from here itself: in which if you can see Table Header (Highlighted Yellow) needs to be Left Centered Table Rows (Highlighted Green) needs to be Left Centered So, I was wondering if this is a possibility…
-
Thank You so much John for your Prompt response, just so we're on the same page, wanted to clarify that, I am okay with Left Aligning everything and not just limited to 1 column. Also, I was wondering if any of these would be useful for the same:
-
Agreed @Christian Berg -Oracle and appreciate your detailed response in walking me through the back-end. I am actually middle of Report Building from metrics in NetSuite and in data validation with NetSuite Saved Search, the first thing I want to look at is number of rows (with same applied filters). Which is why I wanted…
-
Perfect! That's exactly what I was looking for, now I'll treat "myCalc" as an ID Column which is auto-incremental and Grand Total shows total number of rows. Thank You so much @Federico Venturin , you've optimized numerous tedious-repetitive steps. Much appreciated 😊
-
Exactly @Christian Berg -Oracle , because Count* is indirectly taking a Column into consideration, which is why I am trying to have a simple workaround that does nothing but simply count number of rows irrespective of any aggregation. Would you share some insights from this snippet from my previous comment: Let's say, in a…