Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Have you tried this?
{$<Year = {'2024'}>} $(v_total_count)
You can write the Set Analysis in front of the expression:
{$<Year {'2024'}>} Sum(A)
{$<Year {'2024'}>} $(v_total_count)
I tried and into the chart i visualize "Garbage after expression: "$" "
What type of chart do you use?
I've got this in a pivot table
Straigth table, what do you have into variable v_test?
I've got this : sum(FlagLancement)+sum(FlagLancement2)
It's not really useful. I created it for the test.
ok thank you, what do you suggest as an alternative?
I don't understand the request. Doesn't work on your end? The measure also works in a straight table.
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