Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please find the attached file
Hi
PFA
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.