Filter a variable value

[Giuseppe_Alleruzzo]

Hi guys, i've a problem. In my project i've many things to sum and all of them give results by year, month and day.

To simplify my scripts i created a variable "v_total_count" with inside it sum(A) + sum(B) + Sum(C) ....+ Sum(Z)

Now I want to create a chart with months as rows and total count for specific years as columns.

How can i do this without filtering dimensions in my dashboard?

For example as first column i'd like to have count month by month for year 2024

if i have an expression i do Sum({$<Year {'2024'}>}A)

What do i have to do to have the same filter for a variable?

Thank you so much

[Clement15]

Hello,

Have you tried this?

{$<Year = {'2024'}>} $(v_total_count)

[LRuCelver]

You can write the Set Analysis in front of the expression:

{$<Year {'2024'}>} Sum(A)

{$<Year {'2024'}>} $(v_total_count)

[Giuseppe_Alleruzzo]

I tried and into the chart i visualize "Garbage after expression: "$" "

[Clement15]

What type of chart do you use?

I've got this in a pivot table

[Giuseppe_Alleruzzo]

Straigth table, what do you have into variable v_test?

[Clement15]

I've got this : sum(FlagLancement)+sum(FlagLancement2)

It's not really useful. I created it for the test.

[Giuseppe_Alleruzzo]

ok thank you, what do you suggest as an alternative?

[Clement15]

I don't understand the request. Doesn't work on your end? The measure also works in a straight table.

[Giuseppe_Alleruzzo]

I made another test, into variable v_test i put only one sum

Do you know why into the definition of the expression I see "Expression OK" and into the formula all underlined in red, as if there was a mistake?

I don't understand