Expression based on a different dimension.

[avinashelite]

Hi All,

I have a bit tricky requirement, In a bar chart we need to add one expression which should display the values based on another dimension:

eg

table1:

Issueid,month,closed

1,Jan 14,1

2,Jan 14,0

3,Dec 14,0

4,Sep 14,1

5,Sep 14,2

table2:

issueid,month2,open

1,Dec 14,1

2,Dec 14,1

3,Sep 14,1

4,Jan 14,1

My bar chart is based on the month dimension of the table1 i am counting the closed issues, it is working fine . But my requirement is for the same dimension i.e month i need to add a expression which should show the count based on the month2 as the dimension!!!

I have used if condition but its not giving proper result.

If anyone had such a requirement can you please explain how to do this

[tresesco]

Chr(39) is used to create the proper input to valuelist(). And this valuelist() is more important here to understand. It is used to generate synthetic dimension(allows to go beyond the association created in the model). Learn about it, you would love it.

[avinashelite]

thanks a lot tresesco seems to be interesting , i will research more on that.