Hi All,
Im trying to chart multiple datasets on one chart. eg line graph.
Example use case is that we get daily data and want to graph it against standards that we have. Eg production data vs standards or previous years data with current year.
Is this possible and if so how do I structure solution, can I have data sets in two different solutions
thanks in advance.
H
i Chris M (Chris)
As far as I know, it's not possible to chart datasets from different tables in the same graph. What could be done is to add a field to the record with the reference data points. The you could choose the current data points as set 1 and the reference data points as set 2.
This reference field could be a formula or lookup field to your reference table taking the average of previous results for ... the same month for example
There are many ways to build this, I just built a sample using 3 tables:
Historic data: Has the monthly sales total from 2021 to 2023
Current Data: Has the transactions for 2024, from January up to today
Report: A summary table with a record for each month of the year
For it to work in scale, you can automatically link the records to the corresponding monthy summary through automations
Hope it helps!
