Skip to Content
0

Design Studio cumulative sum filtered by a dimension (.UNX source)

Jun 01, 2017 at 03:31 PM

75

avatar image

Hi!

I have a requirement of displaying a cumulative sum in a chart along with a dimension. My source is a UNX universe pointing at an oracle database.

I have managed to do so as explained in another post.

So my initial query result would be something like: (dim, measure)

"Days to complete" "number of projects"

7 3
10 4
11 7
12 12
13 26
14 49
15 50


My problem is that I also need the chart to be filtered by another dimension (department, for example), but to do that I need to add the dimensions to my data source, which make my cumulative sum wrong.

Ideally, I would like to add a filter to the data source without having to include an additional dimension in the selection area of my query.

Can you think of a solution for this problem?

I am using version 16.3.1


Many thanks,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers