Trends on % values

[stevejones1]

Hi

Attached is my file , i am trying to create a trend line based on CSAT values , but when i do not select any value , no data is shown in the chart, where as when i select a casenumber i do see the correct percentage value,

Can someone pls help me to show the trend line

Thanks

[Sergey_Shuklin]

Hello, Steve!

You are using Only() function on your chart. When more than single value of your expression per period is returned the Only() function will be equal Null().

So, dependind of what you want to calculate you should use a correct function. For instance, if you change Only to Sum you will see values on the chart w/o any selections.

[uroboros · Accepted solution]

Hi! In fact, it caused because you're using Only(), and when not have selections you have a null() (Null pointer exception - lol); just try the same with a sum(Disticnt <>) it should be resolve you situation.

PD:
Try this:

Sum(DISTINCT{<CaseStatus = {'Closed'},CSATSent ={'true'},CVAFlag ={1},Indicator ={'Closed'}>}[CSAT])