Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Rolling 12 Months Calculation
Answers
-
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)
0 -
Robert, any chances you can share a DVA with a subset of your data as a source to it, so I could take a look ?
Philippe
0 -
yes, thats what i was thinking, let me get that for you asap.
0 -
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 grabs from Dec 2017 and adds that number in. i tried playing with my calc but nothing worked.
current calc is: MSUM(ROW_COUNT, 12 BY BODY_PART_INJURED)
and for now i am only filtering out all others and only showing one body part injured to make this simpler.
0 -
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.
0 -
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.
0 -
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.
0 -
ok, I just edited my post and added the file to the initial post.
0 -
Hi Robert, I was able to get your project, but it's source is a database. unfortunately I wont be able to connect to your database. To share this project you may need to create a file based version of your example unfortunately. Possible ?
0 -
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 all matched up. does OAC have such a button?
0
