Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Aug 10, 2022 02:20 AM
Hi all,
Sorry for the long-winded explanation but I’m hoping to get my head around the best way to use the chart extension to show project starts for each Quarter. In short, we have a base where each record is a project, and one column nominates a yearly quarter each project to start (ie. “Q1/2021” for projects starting in the first quarter of 2021).
Problem when charting is (1) I can’t seem to arrange the x-axis in the correct sequence, and (2) it doesn’t seem to allow for quarters with no projects starting.
If I sort by ‘view’, it appears to arrange the x-axis by the order in which they appear on the grid:
If I arrange by “X value”, it sorts all Q1 together, then all Q2 together:
If I arrange by “Y value” it sorts by total count for each quarter:
If anyone knows the best way to arrange the data so the X axis is in the right order AND allows for quarters with zero starts, that would be great! Do I need a separate view set up with only that data in the correct order, or can I use the existing view?
Thanks in advance!
AC
Aug 10, 2022 09:54 PM
Hi Andrew,
re: having the X-axis in the right order
I’m afraid the only options I can think of are:
[Year]/[Quarter]
instead of [Quarter]/[Year]
, i.e. 2020/Q1
re: allowing for quarters with zero starts
Hmm, so in a scenario where there were no project starts in Q2/2020, you would like Q2/2020
to show up, but with no values like so?
If so, I think you’re going to need to create a new table that just has all the quarters and create a count field for it, and use a link field to that table as the Quarters
column instead
Aug 18, 2022 06:10 PM
Hi Adam,
Thanks for your time with this. I’ve been playing around with your approach and I think your solution ticks the boxes.
Always happy to hear of other ways to achieve the same outcome, but this works well.
Thanks again,
Andrew