7 Replies Latest reply on May 21, 2013 8:25 AM by Jonathan Drummey

# Measure Activity from Two Dimension Names in one Statement?

I'm trying to measure both incoming and outgoing activity. I have two Dimensions ([OutgoingName] and [IncomingName]) and need to bring all activity together.

I've gotten the desired results with the IF statement below, but I'd rather not replicate the below calculation 200+ times when I know there's got to be an easier way... I'm having trouble realizing the right path.

IF [OutgoingName]="Matt" THEN [OutgoingName] ELSEIF [IncomingName]="Matt" THEN [IncomingName] END

My issue at its is due to data structure, but there's not much I can do about that. Any help would be great.

• ###### 1. Measure Activity from Two Dimension Names in one Statement?

What does the viz look like? How are you using this calc?

--Shawn

• ###### 2. Re: Measure Activity from Two Dimension Names in one Statement?

I'm using a scattergraph to show deviation from activity last year and volume of activity this year. I'm currently not using a calculation because I can't get it right.

Maybe I was misleading in my original post when I stated that I'm trying to measure both incoming and outgoing activity. I'm actually trying to measure all activity, both incoming and outgoing together.

• ###### 3. Re: Measure Activity from Two Dimension Names in one Statement?

What's on the x & y axis of your scatter plot?

Thanks,

--Shawn

• ###### 4. Re: Measure Activity from Two Dimension Names in one Statement?

X Axis = Deviation of activity from last year

Y Axis = Volume of activity this year

Thanks for the help, Shawn

• ###### 6. Re: Measure Activity from Two Dimension Names in one Statement?

So the problem is your screenshot only shows marks for outgoing or incoming, but not both? Have you tried putting them both on the level of detail shelf? You should get marks for both dimensions. You can also put more than one dimension on the color shelf, you just have to drop them on the color shelf at the same time (something Jonathan taught us last week). Combining the two dimensions using "Combine Fields" and then dropping that on the color shelf will give you a different set of marks.

I guess what I'm saying is this doesn't seem like a calculation problem, but an aggregation issue that can be solved using pills arrangement and pill type. Is any of this getting close?

--Shawn

• ###### 7. Re: Measure Activity from Two Dimension Names in one Statement?

It could be a case where the data (incoming and outgoing) needs to be UNION'ed together. This is a good example where posting a packaged workbook with some sample data would be helpful.