Replacing the filed values In Frontend Chart

[Bharathi09]

Hello All,

I have QBS column in my dashboard,
I have to add it as Filterpane in Frontend. In taht column some records are there which starts as 

'No. of days from Assigned to Requested'
I want to show as 'Days from Assigned to Requested'

I have many recoords like this and also have some different records as SP Code, Country Code, which shows as it is there 

How to achive
Plaese help


Thanks!

[rwunderlich]

You could try:

Replace(QBS, 'No. of d', 'D') as QBS

-Rob

[Bharathi09]

Does it works in front end?

I also have other records other than records with No of days from.  Those records has to keep as it is

In this case how to achieve 

[rwunderlich]

Yes, you can use the expression in the front end to create a filter. You'll need to wrap it in an Aggr() like this:

Aggr(Replace(QBS, 'No. of d', 'D'). QBS)

It will only change the string 'No. of d'. Other records will remain unchanged. Give it a try.

-Rob

[Bharathi09]

Hello,

Thanks for replying, I want to keep condition in my KPI such as show the CNSelect values which are less than 29 and greater than 13 and also replace the values which have contains "No. of days" with "Days"

I have tried like this--------- =Aggr(If(CNLevelOrder < 13, Replace(CNLevelSelect, 'No. of days', 'Days')), CNLevelSelect)
But when I am selecting any one value from KPI others are disappearing, I want to see like below

Please reply back
Thanks!