Build line chart with two field

[hafiyuddin_azhad]

Hi, I tried to find how to build a line chart using multiple field. Can please anyone help? Below I put example how my data is.

Week	Status	Price
1	inactive	$2
2	active	$6
3	inactive	$9
4	inactive	$3
5	active	$4
6	active	$5
7	inactive	$1

How can i build a line chart with dimension week and measure inactive=price & active=price?

so it need to be 2 line in 1 line chart.

please assist me. thank you

[AshutoshBhumkar · Accepted solution]

Hello,

If I got this correct, you want to two lines. One for Active and one for Inactive.

Put 2 measures in line chart like below.

Line 1 : Sum({<Status = {'active'}>}price)

Line 2 : Sum({<Status = {'inactive'}>}price)

Thanks,

Ashutosh

[hafiyuddin_azhad]

thank you! it works!

[AshutoshBhumkar]

Great 🙂