Hey Team, Is there a way to hide columns in visualisations?
Example: Date field, total_active_users and PoP for previous 1 month. I only wish to see Date (week, month or Year) and PoP % change?
Any ideas?
Thanks,
Grant
Hi Grant,
At the moment, there is no direct way to hide columns in a table.
If you want to have complete control over the fields, I would suggest creating the comparison fields using our Transform Model (though that may require some prep work).
We’ve written an extensive tutorial about it here: Build period-over-period metrics | Holistics Docs
hi there, okay thanks, I did think that would be the answer. Unfortunately doesn’t really meet my needs.
Thanks,
Grant
Hi @Grant_Orchard,
I’m sorry that the solution doesn’t meet your needs. I guess it might be a bit cumbersome, but I’d like to hear more from your perspective.
On a positive note, we’re actively working on a project called AQL Expression. This feature will allow you to create customized POP columns without predefined columns. It’s designed to address requests like yours, including plotting PoP changes in graphs.
Please feel free to share more details or any additional thoughts you have.
1 Like
This is amazing! looking forward to these new items!!
1 Like
The AQL expression for period-over-period comparison has been launched a while ago. We apologize for not replying to this thread sooner 
To achieve your use case of showing only the “Total Active Users (% change)”:
- You can turn off the current Period Comparison toggle.
- Instead, create an ad-hoc AQL metric using the
relative_period()expression as documented here: AQL period comparison | Relative period.
Please give it a try and let us know if you have any questions.
Thank you!
Phuong.
2 Likes