Need Combined expressions for Line chart

[paolojolly]

Hi, I have the following two graphs

with Month-Year and Item as dimensions for each of the two graphs and in which for each item I have a line with a different color

If I try to combine the graphs and to create a single graph using GRO PRI and NET PRI as expressions

I have the follow result

in which I lose the item group.

I need to have for each item different line (one for net pri and one for gro pri) and using diffent color to identify the different items

Can someone help me?

Thanks

[vgutkovsky · Accepted solution]

That's a really complex requirement...take a look at the attached. That's one way to accomplish what you need.

Regards,

Vlad

[paolojolly]

Thanks for your reply. I have another problem, sometimes the chart does not return me any results and I do not understand why.

I attach the document

Can you help me? Thanks so much

[vgutkovsky]

Try to modify your data model to get rid of that synthetic key. Also, create the Month-Year field in the data model instead of as a calculated dimension. If the problem still persists then, repost the new application and I'll try to take a look.

Regards,

Vlad

[paolojolly]

I solved the problem by adding text () function in the expression

many thanks for your cooperation

Regards,

Paolo