Forum Discussion
gtamir
Post Patron
6 years agofilter a summarised table by date
Hi, I have a summarised table based on the transaction table. Then I have a page with visuals using measures based on the summarised table. Now I want to filter the visuals to one month only. Is it...
gtamir
Post Patron
6 years agoAll the visuals are based on measures
amitchandak
Super User
6 years agoHave you created a separate measure table and referring to that. This means a dummy table with the only measure.
In that, case your measures will respond to the filter of the tables they belong too.
If you have created a summarized table without a date or month, then you have to create it with a date. You can take month start date to group data at month level and join it with the date table.