Hi,
We have graphs which display 12-24 months of data (per month), which can be "busy" to view. Is there a way we can display recent columns (say last 6 months) by months, and older columns group by quarter, so easier to read?
It is also worth noting our data is not actual date dd/MM/yyyy or MM/yyyy driven, as our production month is 16th to 15th, so we have a text column in our data course stating each month ie "Sept 24", which we reference.
Any information would be appreciated.
Hello,
It sounds like there could be a few challenges with your data.
Does your data grow by adding new columns or rows? How do you know which column aligns to which month? Do the columns have unique names or dates?
Assuming your columns don't change, just the data in them, you could group the data by quarters and months using our functions and put them into an ARRAY(). If your columns are also growing and changing, then you'll need additional logic to pick up the new columns which show up into your data.
To fully help here, it would be easiest if you could open a support ticket with the team and let them know which Klip you are working on.
Thank you
Meggan
