Use Key Figures like Characteristics in Querys

[Former Member]

Hello everybody,

I want to use key figures in my query like characteristics.

That means: I have a key figure that shows a certain value e.g. the duration of a process. At the end of a day the user wants to know how many processes took 0 to 10, 10 to 20, 20 to 30... minutes like this:

0-10 min: 5x

10-20 min: 10x

20-30 min: 11x

...

I don't know how to implement this with key figures. In another case we had created seperate characteristics for the key figures so that we had saved the values twice: One as key figure and one as characteristic.

Is there any other possibility?

Kind regards,

Sebastian.

[Former Member · Accepted solution]

Hi Sebastian,

Did you try to solve this with conditions?

Regards

Udo

[Former Member · Accepted solution]

Yes I thought of using conditions. But then I can only define the range of values which I wanted to be shown.

If I wanted to put out this in one workbook or template I would have to create a lot of querys for each range: One for the range 0 to 10, one for the range 10 to 20, one for 20 to 30 a.s.o.

Or am I misunderstanding?