Data does not display for One value

[Anonymous]

Hi

Can someone help in figuring out why data does not display for just one Group-Function Value in the attached application?

Thank you

[m_woolf]

Using TP50 as an example, you have used the only function. If you restrict the date to 9/9/2015, there are multiple values for TP50. Therefore only returns null.

[settu_periasamy]

Hi,

Only function will retrun Null, if there Multiple value. as already said by mwoolf‌

May be you can try with sum instead of Only(). Like

Sum({<ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}TP50)

[jagan]

HI,

Only() will return value if you have only one value, if you have multiple values then you have to use Sum() or Avg() depending on your requirement.

Regards,

jagan.