Hi,
as the topic stats the Trend Line option is not visible. Below you can find the diagnostic info and other maybe important information. Im trying to create trendlines for the 3 lines and if i understood the documentation right thats possible? Below you can find the documentation part about trendlines but i dont fully understand the 2 last sentences fully.
I also tried to create a trendline with random charts, but none of the charts were able to create a trendline. Further below you can see more information. I appreciate every help.
Best regards
The chart looks like the following:
and the area options look like the following:
The sql query:
with
orders as (
select op.*,
ud.kundenkonto as kundenkonto
from "02_business_layer"."orderposition" op
left join "00_raw_layer"."userdata" ud
on op.ordernumber = ud.ordernumber
),
orders_per_day as (
select
order_creationdate as order_creationdate_gesamt,
count(distinct ordernumber) as anzahl_bestellungen_gesamt
from orders
group by 1
),
kundenkonto_orders as (
select
order_creationdate,
kundenkonto,
count(distinct ordernumber) as anzahl_bestellungen
from orders
group by 1,2
),
final as (
select
order_creationdate,
kundenkonto,
anzahl_bestellungen,
anzahl_bestellungen_gesamt
from kundenkonto_orders
left join orders_per_day
on kundenkonto_orders.order_creationdate = orders_per_day.order_creationdate_gesamt
)
select *, 1.0 * anzahl_bestellungen/anzahl_bestellungen_gesamt as percentage
from final
Diagnostic Information:
{
"browser-info": {
"language": "de-DE",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_232-8u232-b09-1~deb9u1-b09",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_232",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.232-b09",
"os.name": "Linux",
"os.version": "4.9.0-8-amd64",
"user.language": "en",
"user.timezone": "Europe/Berlin"
},
"metabase-info": {
"databases": [
"sqlserver",
"googleanalytics",
"postgres",
"mysql",
"bigquery"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "9.6.15"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.39.4",
"date": "2021-06-15",
"branch": "release-x.39.x",
"hash": "f538050"
},
"settings": {
"report-timezone": "Europe/Berlin"
}
}
}