Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Greetings @Bhaskar Konar & @RVohra , I can certainly share the workaround. So earlier the problem was this Formula was used to count Average and it didn't take into consideration of Highlighted Green because technically No Sale was made so no Data for Month: But if we divide Sales by this: This will provide accurate…
-
Thank You @Chere-Oracle, I tried and this Formula didn't worked as well. However, different approach was pursued so this Case can be closed. Thank You for your input ☺
-
Thank You @Jestin Rajan , 18 is basically Internal ID for "Cambridge" Location (ref. Screenshot from above). However, different approach was pursued so this Case can be closed. Thank You for your input ☺
-
Thank You So Much @Jestin Rajan for your Comment. Please Note 18 is just an Internal ID for My Select Filter for "Cambridge": Here's the Full List of Sales Representative Location: I don't think so any Location would be Non-Text Value. But the Great News is, I created this Calculation: And will use this as a Filter, this…
-
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…