Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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.
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])