Hover in Combo chart

[Lakshman_1031]

Hi All,

I have combo chart and i have used Custom Hover.

I have used Expression in Hover is 

='Profit as'& Only({< Month, Year>}Aggr(NODISTINCT Sum(Profit),Year))

If i select year 2020 all the years showing in x-axis and data showing only year 2020.

I want to show only if i select 2020 then display in chart only 2020 on x-axis.

please see the below example for your reference.

Please suggest me is it possible to achieve this scenario, if possible please share example.

Thanks & Regards,

lakshman

[tresB · Accepted solution]

Remove only() from your pop-up expression.

='Profit as'& Aggr(NODISTINCT Sum(Profit),Year)

[Lakshman_1031]

Hi Tresesco,

Thanks for your quick replay.

Is it possible to achieve same scenario without using  Aggr(NODISTINCT).

If possible please suggest me how to do.

Thanks & Regards,

Lakshman

[tresB]

It seems that you are getting at tool tip the total sum irrespective of dimension, that you probably can do like:

='Profit as'& $(=Sum(Profit))

[sunny_talwar · Accepted solution]

May be this

='Profit as'& Aggr(Sum(TOTAL <Year> Profit), Year, Quarter)

[Lakshman_1031]

Hi Sunny,

Thanks for your replay.

I have used same thing in months but i am facing issues.

i have used expression in month

SUm({<Flag2={1}>}Sales)/Aggr(Sum(TOTAL<Year>{<Quarter=,Month=, Year=>}Sales),Year,Month).

if i used custom hover then i am facing issues .

i have created one flag for present data and future data. i have used this flag in hover then x axis showing all the values.

Please see the below example for your reference.

Please suggest me how to achieve this scenario, if possible please share example.

Thanks & Regards,

lakshman

[sunny_talwar]

I am not sure I follow the issue? Can you explain what you need to see with or without selection in the attached sample?

[Lakshman_1031]

Hi Sunny,

Thanks for your replay.

I have created one flag for current data and future data.

i have restricted future data using flag.

Based on the flag data it is Showing current data line and remaining  data is not showing.

For example in the example having 2020 may data and up to May line showing and remaining is not showing any thing. 

but line is not showing but x axis is showing 2021 data without line.

i don't want to show if line is not there. without using Hover it's working fine but when i used Custom hover it is not working.

Please suggest me how to achieve this scenario.

Thanks & Regards,

lakshman