sum by Year

Hello,

I am trying to get calculations based on a few different things, but when I summarize I am duplicating so many of my rows. . Attached is my data file.

Basically what I want is 3 things:

Sum of Opioids Administered by TimeFrame

Sum of Opioids Administered by State and TimeFrame

Sum of Opioids Administered by KDS ID and Time Frame.

My Timeframes are Baseline and Performance. Currently I am using the Sum tool to do each of these individually then joining them back together. In doing so, I am duplicating my rows time and time again. I know there is an easier way to do this.

The attached data is my current output. I really shouldn't have any more rows than the 375 in this file, but I am getting way more than that. Also, I have tried Union and Join.

ALTO Dashboard Output 11182019.xlsx

Datasets

Accepted answers

fmvizcaino

Hi @aberthiaume ,

Attached is an example showing how to accomplish what you need.

Let me know if that works for you.

Best,

Fernando Vizcaino

sum by Year.yxmd

All comments

fmvizcaino

Hi @aberthiaume ,

Attached is an example showing how to accomplish what you need.

Let me know if that works for you.

Best,

Fernando Vizcaino

sum by Year.yxmd

aberthiaume

This is perfect! Thank you!

BrandonB

opiods administered summary.png

Please take a look at the attached workflow. This should provide the summarized data at the varying levels of granularity that you requested. As far as bringing these data points back together, it depends on how you will ultimately be using this data.

Edit: Looks like @fmvizcaino joined it back just how you were looking for!

Summarizations.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335