I have a dashboard with a native SQL query and custom questions based on it. One of these custom questions is a total revenue number, i.e. a single-number chart. I want to restrict period of time using dashboard time filters. The problem is that I cannot apply them to this total revenue chart.
The way the native SQL query is built is as follows:
The revenue chart is a custom question based in this query, i.e. sum(revenue).
I want to enable from and until time filtering but it does not work. I am wondering if this feature is plainly not available or whether I am mistaken in some part. Would appreciate a comment.