Welcome to the Oracle Analytics Community

Products Banner

ROBERT PURDY ✭✭✭

Comments

  • i replaced my workbook with one that has a csv file as a source. try that and let me know if you have any issues seeing my workbook, thank you for your help. i downloaded tableau and all i had to do was click a certain button that said, Include missing values to get the months that did not exist in the data and the numbers…
  • ok, I just edited my post and added the file to the initial post.
  • this is my first time sharing a workbook with OAC, so i hope i did it right. let me know if i didn't, here it is attached. thank you for your help.
  • on Desktop, it is working with just one body part, by month. so now i added another body_part and it got all messed up. i will send the workbook asap.
  • I downloaded desktop, and its working now on desktop, but not on web. I think it has something to do with refreshing, even though i am clicking refresh. i changed it to Live instead of caching.
  • ok i am still going to get you a workbook. this problem is back. when i was verifying my info, my query was wrong, not its right and it matches up from Dec 2018 going backwards to Jan 2018 is all correct but then Dec 2017 rolling 12 back to Jan 2017 is wrong since Feb 2017 has no entry, its like it skips that month and…
  • yes, thats what i was thinking, let me get that for you asap.
  • scratch that thought. its right for the first 4 recent months then its off, and there is a value for 'Back' every single month, so i don't know what the issue is. here is my calc after your video: MSUM(ROW_COUNT, 12 BY BODY_PART_INJURED)
  • Philippe, THANK YOU very much. that helped some, but not quite all the way. I notice if i look at my monthly counts, the most recent months info is correct until i get to Jan 2018 or Dec 2017 and its looking back a rolling 12. I think the issue is that there isn't any value in one month so it doesn't see that data month…
  • I was looking at another report needed, and maybe this will make it easier on the problem we are having. i Added “ROOT_CAUSE” to my query and now There is data every month. BUT its still not doing the MOVING SUM correctly? But if I only look at one ROOT_CAUSE, the number matches my database. But if I do 2 or 3 ROOT CAUSES,…
  • my consultant and I dug in a little deeper. it appears that the body_parts_injured without a value in certain months is messing it all up. if i only show body parts that have a value EVERY month, then it works, but once i add in the body parts that have sporadic records, then the numbers don't match. we've tried isnull,…
  • ok, this is interesting. if i add in ARM alone, the number is correct. I can add in all other body parts as long as they are AFTER the word ARM in alphabetical order. once i add in Abdomen/Torso, the number is incorrect. why? i must not understand this function correctly?
  • i just tried what you said, and you are CORRECT, if i remove body parts, the number is correct. could it be a null or something that is confusing OAC?
  • Philippe, i had already added a field in PREPARE named Row_Count with a 1 value column. I was wondering if this is best practice, so thank you for saying that. I removed all from my report and only put in Date_of_incident, then show by Month, and added the ROW_COUNT dummy field. the number matched my database. so then i…
  • Ok great. Thank you for your help! I will use this when asking a question on this forum.
  • yes, it helps, thank you. i just want to make sure they are kept in sync (for the most part) or if not, then as long as i know which one Oracle focuses on, then i'll use that method. sounds like they are kept in sync. is it possible when in DV Desktop to save my local data in a file and then upload it to this forum in…
  • Philippe, I am new to Oracle Analytics Cloud (but not new to BI tools - 25 years). I currently develop on the web. Does DV Desktop offer me anything different or better than the web version of editing?
  • Lalitha, your answer worked for me! thank you VERY MUCH! and yes, i can also use the STACKED BAR CHART as well. i found that after i posted this and that is a great solution to. here is what i ended using for my formula: i had a field called Total_Count which just has a 1 for each row. Total_Count /sum( Total_Count by…
  • on the left, i was able to get it to work in a pivot table,but the options: DISPLAY AS: PERCENT OF AND PERCENT OF: ROW VALUES does not show up in a LINE CHART. so i am at a loss.
  • No, we don't use classic OAC.