graph legend

[mayathebee]

In the data label of the chart expert I have onchange of (month/year AND campaignID) show nr of products (it is a multi bar chart). My legend shows the campaign ID, which to the user means nothing. How do I get the campaign name to show instead of the campaign ID?

 

[pgtek]

hi
Just create a formula for the id
ex:
@campaign
if
campaign ID = 1
then
"RED"
else
if
campaign ID = 2
then
"BLUE"
and replace campaign id with this formula in your legend


cheers

pgtek

cheers

 

[mayathebee]

Hi pgTek,

Thanks for your reply. I don't know what the ids will be, as they can be any number of ids. Could you guide me into a direction to do your formula idea still?

 

[pgtek]

hi
you must have a table call campaign id
and a name associate to it

just create a formula base on that

or
replace the field in your graph with the campaing name instead and change your group from id to campaing name

cheers
pgtek