chart calculation

[mambi]

Hi everyone,

from the table below i want to make a chart so for every country if the 'music' info exists the chart bar display 1 else 0

Country	Market
France	video games
France	music
France	books
France	tourisme
Spain	books
Spain	tourisme
Deutch	video games
Deutch	music
Deutch	books
Deutch	tourisme
Deutch	cars
Deutch	job

thanks

[#2]

Please find the attached file

[MayilVahanan]

Hi

PFA

[Anonymous]

You can easily make a Flag Field in the script.

IF(Market = 'music' , 1 , 0)  as _musicflag

Then you can use _musicflag as your dimension in the chart.