Adding filed format to dynamic field names

[gajananh999]

Dear All

Hope you are doing good.

I want to add the $ to my data but field name is dynamic so how can i add $ to my data which is coming for dynamic field

like this ex

Product 20-25 30-35 35-40

prod 1 $1,000 $2,000 $3,000

prod 2 $4,000 $5.000 $6.000

If there are actual field like age then i can do it by age= "$"+ age
but here i don't know the how to do for dynamic field

Can anyone please help me on this.

Thanks
Gajanan Hiroji

[aholzer · Accepted solution]

Try this:

chart eval("$"+sum(Total_Covered_Amount)) over Product_Name by Age

[aholzer]

This should do the trick:

eval("$"+toString(sum(Total_Covered_Amount),"commas"))

[gajananh999]

Its done eval("$"+tostring(sum(Total_Covered_Amount),"commas"))

This will gives you commas also..

[gajananh999]

Ya Thank you .... this works fine for me can you please tell me how to add comma for that value

[gajananh999]

See This is my search :
index="inforce_analytix"|eval Age=2013-Subscriber_Year |bin Age span=5| chart sum(Total_Covered_Amount) over Product_Name by Age | rename Product_Name as "Product Name"

I want get data like as i shown in above comment so the so here field will be like 20-25,25-30,30-35

[rgcurry]

For me, your question is not quite clear. In your example, what is the "dynamic field name"? What makes it dynamic? If what you are asking is the value of those items in your example as "prod 1" and "prod 2" change, how is that represented in your data source? Please provide an exmaple of the data source and perhaps we can find a way to get what you want.

[gajananh999]

Can Anyone reply me on this.