By default, only the last week of the date is displayed, but the bar will show the pick time dimension when the date is selected in another chart.

[Li_Bing]

Dears,

Please refer to the picture. Since my bar chart is set to hourly dimension and date dimension, the metric is order count,

Since I have too much data in the date dimension of the bar chart, how do the bar chart control the date dimension? By default, only the last week of the date is displayed, but the bar chart will show the pick time dimension after the date is selected in another chart.

Thank you very much.

[Aditya_Chitale · Accepted solution]

Try this:

if(GetSelectedCount(Date),  Sum(Value) ,  Sum({=$(=weekstart(max(Date)))<=$(=max(Date))"}>}Value))

And uncheck 'include zero values' option under add-ons -> Data handling.

Regards,

Aditya

[Li_Bing]

• This formula suggests an error. Is it formatted incorrectly?

[Li_Bing]

Error in expression:'}'expected

[Li_Bing]

• Error in expression:'}'expected

• This formula suggests an error. Is it formatted incorrectly?

[Aditya_Chitale · Accepted solution]

Sorry, It was a copy mistake from my end.  Please use below expression

if(GetSelectedCount(Date),
Sum(Value)
,
Sum({<Date={">=$(=weekstart(max(Date)))<=$(=max(Date))"}>}Value)
)

Regards,

Aditya

[Li_Bing]

• It works. It's perfect. Thank you very much