Set Analysis Help for Sparkline

[#1]

Greetings,

For one of the projects I'm currently working on I'm trying to show the yearly trend of production.

My formula for the sparkline is: =only({$<Week={"<=52"}, Group={'Structural'}>}[Raw Production ])

The expression definition box says the expression is ok, but nothing populates the desired cell.

Any help with correcting the formula would be greatly appreciated!

-Nick

[JonnyPoole · Accepted solution]

the only() function is intended to render a value if there is only 1 value to render. If there are 2 for that data point it will render null() which seems like a possibility.

what happens if you  sum() the values instead ?

also what is date or time based  dimension being used for spark line ?

[#3]

Jonathan,

The sum() function worked... I could have sworn that it didn't the morning, but that was before my first cup of coffee.

Thanks for the quick reply!

-Nick