Operations with the value of a visual

[Syndicate_Admin]

Hello:

I have the following board and I need to make a percentage chart similar to the other charts for the value of COMMITTED:

el indicador seria COMMITTED / PAST COMMITTED.

PAST COMMITTED is filtered by months 1,2 and 3 for the total value of COMMITTED, but I don't know how to capture that value in order to do the calculation.

I tried to put a segmenter but it modifies the other values in addition to the graph. Is there a way to be able to declare a variable that is the value of the filtered visual and thus be able to do the calculation that I propose?

[amitchandak]

@Syndicate_Admin , You have use same visual level filter in other visual too

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Syndicate_Admin]

Hello:

I have a variable called COMMITTED and it contains information for the 12 months of the year, this data is updated every month

What I'm looking for is to be able to calculate an indicator on the progress of that variable month by month, so for the month of March the indicator would be

PAST Committed (sum of January+February+March) = 3,980 divided into

Committed: (todos los meses)= 20.329

PAST Committed/Committed = 3,980/20,329 = 20%.

So the question is how do I create a variable that is called PAST Commited, so that I can select the months?

I was thinking of putting a visual and applying a filter to it, and then if possible take that data from the visual and turn it into a variable called PAST COMMITTED so that I can divide it into the variable that already exists and is called COMMITTED and be able to calculate the indicator.