Cumulative measure in Key Value graph, filtered by Drop down list

Bliss — Fri, 10 Mar 2023 12:18:11 GMT

Hello,

I'm trying to do the following:

Objects

Drop down list control || assigned variable: Date (format YYQC5)

Key Value graph || assigned variable: either Measure 1 (Cumulative total) OR Measure 2 (CumulativePeriod)

The Drop down list is filtering the Key Value.

When selecting a date in the Drop down list, I'd like the Key Value to return the cumulative total up to the date selected in the Drop down list.

Example:

Data

Quarter || Amount

Q1 2022 || 100.000

Q2 2022 || 125.000

Q3 2022 || 75.000

Q4 2022 || 100.000

Objective

Selection: Drop-down list = 2nd Quarter 2022

Results: Key Value = 225.000 (100.000 + 125.000)

Actual Results

Selection: Drop-down list = 2nd Quarter 2022

Results: Key Value = 125.000

How should I proceed?

additional info:

release: 8.5.2

Re: Cumulative measure in Key Value graph, filtered by Drop down list

acordes — Sat, 11 Mar 2023 20:37:31 GMT

There are several ways to solve this.

If the quarter is defined as "date" then you can use the quarter in a slider as page filter. The key value shows the accumulated value.

Or assign a parameter to the quarter selection and apply a filter in the key value object.

topic Re: Cumulative measure in Key Value graph, filtered by Drop down list in SAS Visual Analytics

Cumulative measure in Key Value graph, filtered by Drop down list

Re: Cumulative measure in Key Value graph, filtered by Drop down list