I am using simple histogram chart and drilling down from a histogram column (for example, Account count in x-axis and territory count in y-axis). It takes all the filters and passes to drilled charts (which is good so far). But one of the filter(which is on account count) is put as "is between [right-exclusive)". Because of this the result does not match. But if it would have put as "is between [inclusive]" then the results match. How do I tell the "drill into option" to use [inclusive] instead of [right-exclusive)?
Hi Dev_Rana!
Your description is right, that is the looker behavior expected.
Did you try creating a new date dimension based on the original date and adding +1 day in the dimension ?
Best!
Leo
Hi Leo, thanks for your reply. But looking further into this issue, I see that the issue is with “histogram” visual control that is available in looker marketplace. The issue is as follows:
Is there any setting in this histogram visual chart so that the last column also follows the same rule as other column?
Not sure of your suggestion of creating a new date dimension. How does it relate here?