Usually, when using toggles, we refer to using parameters. However, it is also possible to create a toggle using a dimension and its two members (two because a toggle is either on or off, true or false, 1 or 0, A or B - or, you would have to "make it two" by whatever logic … Continue reading A toggle without using paramaters
Month: November 2023
A(nother) quickie on bar chart labeling
A quick one for today. How do we get from this to this? There are several techniques and I have described one >> here << already but the one for today is this: add a secondary axis to your columns (sum(0)) Dual axis, synchronize create two calculated fields, one named "label +" the other "label … Continue reading A(nother) quickie on bar chart labeling
How to do a count distinct over a rolling window
Recently a user on the forums asked how a distinct count over a rolling window could be done. Easy, you might say at first. Just use countd() and all be good. And that is true - and it is not. The problem we are facing here is that the usual countd() combined with say a … Continue reading How to do a count distinct over a rolling window