Have x-axis time labels adjust along with granularity selection?

Sam shared this idea 5 months ago
Idea Logged

I'm close to launching a dashboard. I showed this chart today:

/718dcb852b270839b357b70fc8677c21

And the feedback I got was that they don't like the inclusion of the time 12:00AM when the chart is showing days/weeks/months, and they'd prefer the value to be centered under the bar. I can't simply change the data type to a date, as this chart also allows for showing data at the minute and hour level. Is there any way that the x-axis time labels could adjust in granularity to match the granularity level selected at the top of the chart?

If that's not possible, their other request was, could the 12:00AM appear on a separate line immediately below the 01/01/2022, so that there's more space between labels?

I said I wasn't sure but I'd check so that either way we can know and go forward. Thanks for any guidance you can offer.

Comments (9)

photo
1

Hi Sam,

Thanks for reaching out. Its not currently possible to set up a multi-line axis label as you are describing, but I can make a request to developers to look into implementing a solution for this in a future cersion of the software. Does this sound like a good way forward?

Thanks,

Eric

photo
1

Yep, I figured neither of these would be possible right now but wanted to do my due diligence. Multi-line axis labels would be a feature request, as would be labels that adjust with the granularity selected in the chart (e.g., don't show timestamp if the selection is day/week/month/quarter/year). Thanks for the quick response Eric!

photo
1

Hi Sam,

Thanks for the reply here. Just to clarify, what type of field specifically is this? I have this shown as a date field currently


bd2133a944d770ec33fee5c53fcda145


At this point I would want to see a "date and time 2 lines" type option in the chart axis settings menu, when the axis is a date field. Does this sound accurate?

Thanks,

Eric

photo
1

The field format is "Timestamp." The data is rainfall amounts in 15 minute increments. If a member of the public selects "Minute" or "Hour" for the resolution, so they can see how a storm played out over hours or days, the timestamp part of the label is essential. But if they click "Month" it no longer makes sense to show the timestamp part. It would be desirable if this axis label could format to the correct resolution to match the selected granularity of the chart. This is probably tricky but would be the ideal feature.

A separate request is what you describe, an option to put the time below the date to save room on the x-axis. In the axis menu setting sounds right.

photo
1

Hi Sam,

Thanks for the reply here. I think I can see what you mean - Personally I would want a feature that adjusted the axis label, to align with the time series visible unit selection - ie "January" vs. "01/01/2022 12:00 AM". Does that sound like what you're looking for here?

I could see this as a "time series granularity" type option either in the field formatting or axis settings. I would have thought this functionality request would exist already in our dev platform, but I can't find it yet. If you can confirm I can either get something new submitted or do some more digging with the team. Let me know what you think.


Thanks,

Eric

photo
1

Yes I think you've got it. If you can file a new request with the dev team that would be swell. Thank you.

photo
1

Hi Sam,

I was able to find this existing ticket in our platform, would you be able to confirm whether this Idea covers what you're looking for?

https://community.yellowfinbi.com/topic/chart-showing-week-by-week-data


Thanks,

Eric

photo
1

Hi Eric,

I glanced at that post and didn't follow it fully, then skimmed the discussion and linked issue. I don't have the bandwidth to evaluate and this feature request is not a high priority for me so I will abstain from judging whether it's a duplicate - I defer to your judgment here.

Thanks for checking into past tickets!

Sam

photo
1

Hi Sam,

I've gone ahead and created a developer task to look into implementing this type of functionality going forward. Updates to the task will be provided here as they become available. I'll in turn mark this ticket as Idea Logged for now; feel welcome to reply here with any related inquiries.

Thanks,

Eric