Charting Help

Question

I need help with a best practice on charting information, using data entered monthly. I will try and explain below...
We have lots of data we track by monthly numbers. I have setup a simple table to allow a user to simply input the total number of events for that month. I would like to display these in a chart, based on FY, but don't really want the label to be 10-1-2023, as an example. I would rather have Oct as the abbreviation. I can't figure out how to do this and still be able to display in the correct chronological sequence. If I just use month names, I can only get them to display in an incorrect order.

------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------

markshnier__you · Answer

QuickBase used to have amazing in person annual conferences. &nbsp;They would fly in a lot of their key staff, and there would be customer testimonials, and a chance to be one on one in person with software engineers and Product Managers. It was also an opportunity to network with the extended ecosystem of Quickbase Solution Providers, (now, imho unfortunately) we are renamed, Quickbase Partners, who offer various add-ons and extensions to QuickBase, or &nbsp;do contract programming or more complex integrations. &nbsp;&nbsp;
For me, not surprisingly, &nbsp;it was the highlight of my year, and I would plan a trip to be in that part of the country to attend the conference and visit as a tourist whatever was worth visiting in that state. &nbsp;The downside for a lot of potential attendees of course was the cost. If you wanted to stay on site at the fancy convention hotel, the rooms were going to be $400 plus per night plus airfare, plus the convention fee itself, so a lot of companies wouldn't pony up that cost for their employees to attend and of course, there are Quickbase users in other English-speaking countries which are further away with higher airfares. &nbsp;&nbsp;
Then we had that lovely pandemic and it short notice. Quickbase did an amazing turn on the first pandemic year because Covid hit in like March and they had a convention in June that was completely online. They replicated the look and feel of the Empower convention, but did it virtually. &nbsp;
Since then, Quickbase decided to redirect &nbsp;their in person efforts more into regional smaller industry events, where a handful of selected top-tier Quickbase Partners get to exhibit and they tend to focus on the particular vertical, say the build industry, construction, and invite decision makers in, say, the construction business to come to the convention. &nbsp; They feel that's a better way to get new potential customers to understand Quickbase. &nbsp; As I can see you were rapidly coming to know, QuickBase has truly amazing capabilities, but it's a very hard sell to explain to Decision Makers who don't know what Quickbase is what it's capable of.
There is an EMPOWER event on May 8th, so block that day in your calendar and they will announce details closer to the date. &nbsp;It will be virtual, and we don't know yet if it will just be a 2 hour thing or a full day of content. &nbsp;Ideally, at a minimum, they recap the main new features that were rolled out in the past year, but more importantly, lay out the Product Development roadmap for the next two or three years, so we can all understand what their priorities are. They have put out a "Call for Speakers" (meaning real customers talking about their real world use case successes), so that is a hopeful sign that they plan more than a two hour event this year.
------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

chayceduncan · Answer

Best suggestion is to use MM/YY as your labels. So instead of 10-1-2023 you could do 10/23
You need it as MM so that they go 01 - 02&nbsp; - 03 etc------------------------------Chayce Duncan------------------------------

markshnier__you · Answer

Have you tried simply having the report group the X axis by month as opposed to by Equal values. Then it will read like OCT 2024.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

tonygonzalez · Answer

Mark, I have, but can only do via month. Month and FY are different fields.

------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------

tonygonzalez · Answer

So that would still be a text field, right? I could do that, but would require I pre-populate that field with all the iterations of month and year. Seems a little cumbersome.

------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------

Forum Discussion

Charting Help