Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can able to create with the types not with the years. How to create multiple lines with years as columnd
@rammiee93 I see. Then you may need to transform your data to row and column format using cross table
// Here * means all the fields displayed as Year. So try to include other columns at top and use * to represent all Year field which you want to trasnform
CrossTable(Year,Value)
Load Type,
*
FROM Source;
if you have few more columns in data, you can update your code
CrossTable(Year,Value,3)
Load Type,
Field1,
Field2,
*
FROM Source;
Now , create line chart with two dimensions
Add Year as "Group" Dimension and type as "Line" Dimension .
Then use your measure eg sum(value)
@rammiee93 create line chart with two dimensions
Add Year as "Group" Dimension and type as "Line" Dimension .
Then use your measure eg sum(value)
@Kushal_Chawda Any help on this?
@rammiee93 Why you have used valuelist? You can directly add Year field itself
There is no field called Year, each year is a column
@rammiee93 I see. Then you may need to transform your data to row and column format using cross table
// Here * means all the fields displayed as Year. So try to include other columns at top and use * to represent all Year field which you want to trasnform
CrossTable(Year,Value)
Load Type,
*
FROM Source;
if you have few more columns in data, you can update your code
CrossTable(Year,Value,3)
Load Type,
Field1,
Field2,
*
FROM Source;
Now , create line chart with two dimensions
Add Year as "Group" Dimension and type as "Line" Dimension .
Then use your measure eg sum(value)