cancel
Showing results for 
Search instead for 
Did you mean: 

line chart with multiple line for same measure in SAP ANALYTICS CLOUD

former_member258682
Participant
0 Kudos

Hello Experts,

I have a requirement to display multiples lines for a measure based on different dimensions.

From the picture "data1.PNG" that I have uploaded. I want Date on x-Axis and want multiple lines(based on product) in line chart for price.

One line for Soap and other for Shampoo.

What I tried is-> in the picture "calculation.png" which can help me do the same.

But the issue is that Product data can be updated any time in future and I cant keep making calculated columns always.

"Output.PNG" is the desied output chart.

Is there any solution for it?

PS- Its just a dummy data.

data1.png calculation.png output.png


Accepted Solutions (1)

Accepted Solutions (1)

former_member196805
Contributor

Is it something like this? If yes, try set column "Product" as Color.

former_member258682
Participant
0 Kudos

Hi chapmanwong ,

Thanks for the reply, I do not know why I was not able to select this option, but when I created it again worked for me.

Answers (2)

Answers (2)

amitrathi239
Active Contributor

Have you tried with creating two calculated measures annd than use in chart.

former_member258682
Participant
0 Kudos

Hi amit.kumar71 ,

I have already tried it, (in picture: "calculation.PNG")

But the issue is that dimension can be updated in the future we can have more products there,

then we cannot create measure again & again for new values of dimension in future.

Thanks,

Sarthak Srivastasva