min(Value)

[Frank_Hartmann]

Hi QV Community,

i have the following table:

Now i would like create a diagramm with "Date" as dimension and only showing the minimum Value of Metric for the corresponding month.

For example:

2015-01 ---> 3 and 1, so datapoint should be 4

2015-02 ---> 2 and 5, so datapoint should be 7

2015-03 ---> 3 and 0, so datapoint should be 3

Has anybody the clue how to construct the formula??

thx in advance for helping

[swuehl]

1) Use Date as Dimension

2) as Expression:

=sum( aggr( min( Value), Date,Metric))

[Frank_Hartmann]

Thank you

[Frank_Hartmann]

One more question:

to get to the above table i had to set some filters.

so the  sum(aggr(min( Value), Date,Metric)) is only working for the original table without setting the filters:

But i need to set one filter for "Usecaserelevance=1"

I tried like:

sum(aggr(min(sum({$<UseCaseRelevance={'1'}>}Value)), Date,Metric))

but this is not working

Any ideas?

[MayilVahanan · Accepted solution]

Hi

Try like this

sum(({<UseCaseRelevance={'1'}>}aggr(min({<UseCaseRelevance={'1'}>}Value), Date,Metric))