Daily average in time series

Hello all, I kinda need help to generate a time series based on

 → daily average scores

How do I do that? Currently my time based series on shows only average and sum of the whole period, but not broken down to daily reads. Please help…. Thanks in advance

Date Distance (km)
1/1/2023 2
1/1/2023 4
2/1/2023 3
3/1/2023 5
3/1/2023 4

Expecting a time-series graph that reads

1/1/2023 → 3km

2/1/2023 → 3 km

3/1/2023 → 4.5km

0 3 114
3 REPLIES 3

Dawid
Participant V

Have you created a measure of type - averagem then you only need date as your dimension and average would be calculated automatically. Show us some code and visualisation/data table, to see where things are not going the way you want.

Hi Dawid,

Thank you for replying. I sincerely appreciate it.

As you see below, I am supposed to get data for each bar, but i just get 1 bar on 1st Jan, but I have data for other days. I did not write any code though…...

2ac7c246-1b6f-44a7-9089-06249aad4c4b.png

Dawid
Participant V

But I don’t see how you built your query, what the data is modelled like. You’re asking for an answer but we don’t know anything to form a concrete answer. 

Also, if this is Google Data Studio, then this is not the community for it 

Top Labels in this Space
Top Solution Authors