Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
This formula suggests an error. Is it formatted incorrectly?
Error in expression:'}'expected
This formula suggests an error. Is it formatted incorrectly?
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
It works. It's perfect. Thank you very much