Hello everybody.
I'm having some problems with my viz.
I want to hide some columns and only show the last 10 months. The problem is that I need the accumulated data until today's date.
When I use the filter to only show the last 10 months, it also filter the data.
Anyone know how to filter the column but not the data?
Thanks a lot!!
3 answers
The trick is having an object/entity to hide. If you're using date/month on column, that gives you a reference point. In your case, we can use a ranking/indexing calc to give us a position in the table. Then we just need to make sure we keep only 10 items. You've got a couple options:
- Drop something like this onto Columns SIZE()-INDEX() < 10 Then hide anything that says False (right-click False text and select Hide)
- Use a date filter to accomplish the same: DATEDIFF('month', [DateFieldHere], TODAY()) <= 5 Then drop this onto columns and hide False values
