Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
this might be really simple, but i can't think of an elegant way of doing it. For example you have a graph with a monthly value, and the data is retrieved only half of the last month, because then is when you last refreshed the report. How can i make the chart ommit the incomplete month?
See attached image, in this case in august the data was retrieved only partially, and i dont want to show it. I don't want the user to filter it himself, i want to do it by default. So it would end up only Jan - Jul values. And let's assume the metric is something like sum(apples)
Selecting only complete month data from the database is what it comes to my mind, but maybe there is a more elegant way?
Thanks!
Hello,
I would create a calculated dimension in the chart:
=if(Month(MyDate) < Month(Today()), Month(MyDate))
And uncheck "Show Nulls" in chart props --> dimension.
HtH
Roland
P.S.:
You can also use the definition above within groups.
Hello,
I would create a calculated dimension in the chart:
=if(Month(MyDate) < Month(Today()), Month(MyDate))
And uncheck "Show Nulls" in chart props --> dimension.
HtH
Roland
P.S.:
You can also use the definition above within groups.
Yes, this was indeed easy I guess i'm just tired. Thanks!