Hi Atif, just a little further information - please could you upload a screenshot of the Parameters selection as well?

Hi everyone, sorry for the late response - the issue turned out to be a non-issue as it was related to some performance issues which have since been sorted by the Admin team managing this instance, but thanks for the responses!

Hi again, Pawel! Have you tried using an Aggregate step in the initial dataflow after you've added the column. You can choose whether the column is a measure or an Attribute. Please will you try that and then let me know how it goes, and i'll look into other things if it doesn't work? You can also try adding a CAST…

Hi although the insight function has been removed, please see this thread for an alternative method :

If you copy the /appdata/local/DVDesktop file and move that across to your new laptop, I believe that all of your projects will move across. If you don't know how to get to that location use Win+R and type appdata and just click through .

Great, let me know how it goes! I think it should work, but if not please let me know and i'll try to think of something else!

Hi Pawel, thanks for replying. I see what you mean now - and agree that this is a function that should be available, but I can't see this function at the moment. However a consolatory fix could be this: Create the following calculation CASE WHEN Task Category= 'Standby' THEN 1 ELSE (CASE WHEN Task Category= 'Urgent' THEN 2…

No problem. I haven't really tested this rigorously, but from the looks of documentation then there should be no limit on rows on a live DB connection. Obviously cached "non-live" data DB connections will have some limitation - but live DB connection doesn't appear to!

Hi there, I believe that there are some limits on data: I think there is also a limit on the number of columns that one can use in data visualizer.

Hi Pawel - as far as I understand it, if you change the order of the columns in the data elements tab, it should change the order of the columns in the pivot. Please let me know if I've misunderstood your question though e.g. vs

Hi there, I think you need to use a "SUM by" function to get this output e.g. I used SUM(Amount by ID) as a calculation to get the required output (as seen in screenshot)

Hi there! It seems to be changing all of your values to attributes. If you go to the data tab and select the newly created table, and "Edit" it, you can find the columns that should be measures and right click, you can very easily change the properties of them (including change data type) e.g. Please let me know if this…

Hi - well if you would want the values to be measures straight out of the data flow, use the Aggregate function in the data flow and set aggregations on the columns that you want to be measures on output. This should resolve your problem. Aggregating a column usually outputs a measure rather than an attribute. Do the…

No problem, please will you mark the answer as correct so this discussion is resolved?

Hello there, From the sounds of it you should just be able to do Sales/SUM(Sales) - The SUM(Sales) should give you the total number of sales in the table. This should ignore the filter settings for the calculation. Please let me know how you get on!

Hello there, I downloaded the Customizable Skin plugin from https://www.oracle.com/solutions/business-analytics/data-visualization/library.html The .css file that you want to edit is the editedreportstyles.css file. To remove the functionality of the side panels (although it's not the prettiest way of doing things without…

Hello there, The insight feature has been removed as far as I can tell - and has been replaced with the "storyboard" function in the Narrate tab that can be presented. A potential workaround is to use the "duplicate canvas" button and then dragging the "duplicated canvas" into the storyboard in the Narrate section in place…

Hi Steve - Do you know where I can find these files on a Mac?

Hello there, In some visualizations (e.g. bar charts, line graphs) you can change the axis label name using the "Axis" section of the Data Elements panel (where you can set your visualization title, analytics, date format): Let me know if this has helped!

Hello there, As far as I can tell, it doesn't matter. I've just created a map with mockup data based on Dublin, Ireland and managed to get pretty accurate results with just columns of "Street Address", "City", and "Country". I tested against Longitude and Latitude and it was pretty much spot on. I don't think specific…