Dynamic scaling of X-Axis
Hello team, based on a "Report Link" field I have added chart to my record form that prefilters the information shown in the chart below based on the opened record. However, I would also like to li...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI can think of a couple of ways to do this, depending on the specifics.
The "Parent" record has a [Start date] field. Can you tell me which weeks you want to show the chart based on the start date? Maybe give some examples?
I would like to display the records from three weeks before and after the currently opened/viewed record.
However, I would say that this is not a parent record; it is simply a single record that is currently open from the table.
- MarkShnier__You
Let's call the "Parent" record the Reference record. Somewhere on that record there is a reference date and I will call the [Reference Date]
Let's call the table which holds the graphs the details table. on that table, I will refer to [Invoice Date]Go to the reference table and make a new formula date field called Reference Date Sunday.
FirstDayOfWeek([Reference Date])
then go to the details table and make three formula date fields which will calculate the first day of the week of the week before the invoice date and the week of the invoice date and the week after the invoice date.
Invoice Date Week with formulaFirstDayOfWeek([Invoice Date])
Invoice Date Week minus 1AdjustWeek([Invoice Date Week], -1)
Invoice Date Week plus 1
AdjustWeek([Invoice Date Week], 1)
then on the Reference record table make three report link fields to match Reference Date Sunday with respectively those three fields in the details table.
then put three charts on your reference record
If that is good enough, then we're done. Otherwise, I have another method or two but they're a little more complicated to set up.
Hello Mark,
Thank you for your response. However, the chart I added to the table is already based on a report link for a different field—in this case, the "Platform," which is filtered using the report link functionality for "Pants." As a result, I am unable to select the "Start Date" as the reference link field.
I attempted to implement the x-axis scaling using the following function, but unfortunately, it is not working as expected.
Chart Filtering Option:
Field properties:
Do you have any other suggestions for how to effectively realize my idea in just one chart?"?
I have also tried to manage the x-axis scaling via Query now on the Chart "customization site". However, Quickbase seems to be unable to interpret the any additional dynamic references apart from the "Report link field" functionality.
Thus, I will work on a 2nd table and will create a field that combines information of different fields I want to use for the dynamic filter, which will then enable me to create the chart I am looking for based on a single "report link field".
Do you have another idea that might work ?