Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

one line chart instead of two line charts

Hello All,

Current i got  two Line charts,

1) First  chart as    Dimension: Time,Type

                            Measure: sum(distinct value)

2) second chart as Dimension :Time

                            Measure: count ( customer)

and then i place one chart over another chart.

so i want to known  is it possible to achieve same requirement in one chart instead of two charts ,

i mean the first expression should use two dimensions(Time,Type) and the second expression should use only one dimension (Time)

11 Replies
arulsettu
Master III
Master III

try this

count(<Type>customer)

kunkumnaveen
Specialist
Specialist
Author

Hi

count(<Type>customer)


will it wont consider Type dimension for second expression?

kunkumnaveen
Specialist
Specialist
Author

It is throwing me an expression error ......

kunkumnaveen
Specialist
Specialist
Author

Any more suggestions  plzz......

arulsettu
Master III
Master III

may be this

count({<Type>}customer)


or


count(Total <Type>customer)

kunkumnaveen
Specialist
Specialist
Author

It just ignoring Type dimension  for both the expressions ..

Anil_Babu_Samineni

Why Not Combo Chart? Using two expressions

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
kunkumnaveen
Specialist
Specialist
Author

combo ok ,but what about dimensions ..i need to use two dim for 1st exp and only 1 dim for 2nd exp...is it possible in combo

Anil_Babu_Samineni

I recommend you to create Group for first dim's then use another dim then choose expression then try.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful