Line Chart with 2 Dimension and 2 measures

[vitaliichupryna]

Hi, 

Is this possible to create chart with different dimensions on (X axis: dimension1, Y axis: dimension2) 

Thanks,

Vitalii

[Channa]

y axis need to be measure only for line chart

but if y_axis is limited try to create multiple measures,each dimension value is one measure

[UncleRiotous]

Not sure if it's what you're looking for but I've managed to get two separate date fields in different tables to work as a single Dimension by using the IF statement.

Rec_Eff_Dt is exclusively in one table while Create_Date is exclusively in a different table.

I built a chart with a Dimension of Rec-Eff_Dt and added a measure that worked off that.  For the second measure (where I needed to use Create_Date as the Dimension) I used an If statement to link those together and count the Project IDs.

=count (distinct if(REC_EFF_DT=CREATE_DATE, PROJECT_ID,null()))

This won't work for everything but it worked for me with two date fields because they were the same and I wanted them overlaid.