AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
3.6K members online now
3.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Current month shows previous month

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Hi Team,

I have got a problem, I'm trying to generate bar chart with month wise calculation, but the chart displays previous month to it's respective date, e.g. my data has date '20170427' and it's shows as March 2017 in chart. I have created custom date column with this format (TODATE(Today, 'DEFAULT_DASH', "%Y%m")).

Note: Today is my current date column coming from data itself.

Can I know what wrong I'm doing here.

 

Thanks,

Kunal

Current month shows previous month

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Any chance you could provide a screenshot?

Re: Current month shows previous month

[ Edited ]
Follower ✭ ✭ ☆
# 3
Follower ✭ ✭ ☆

Please see below Bar chart and Data files screenshot.

For e.g. my data file have 2 records for August month (it shows data as July in bar chart) and 5 records for September month (it shows data as August in bar chart)


@Litmon wrote:

Any chance you could provide a screenshot?


Bar Chart

Bar Chart.JPG

 Data file

Data.JPG

 

Current month shows previous month

Follower ✭ ✭ ☆
# 4
Follower ✭ ✭ ☆

I would like to know if there is any solution or workaround to this problem.

Current month shows previous month

Explorer ✭ ✭ ☆
# 5
Explorer ✭ ✭ ☆

Hi Kunal, 

 

I'm trying to your chart, but i don't have the values of your axis-X and axis-Y

Does the bars represents "Level" ? 

Current month shows previous month

Follower ✭ ✭ ☆
# 6
Follower ✭ ✭ ☆

Hi Patrick,

Bar chart should provide count of members per month.

X-axis shows count

Y-axis shows months.

Let me know if you need actual values. Also, how should I share them?

Re: Current month shows previous month

Explorer ✭ ✭ ☆
# 7
Explorer ✭ ✭ ☆

i did already a spreadsheet, maybe i should have another fields with count of members per month

Did you some custom fields in your data studio report in relation with your data source ? 

 

You can share a picture of your actual values if fields are different than mine.
kunal.PNG

 

 

 

 

Re: Current month shows previous month

[ Edited ]
Follower ✭ ✭ ☆
# 8
Follower ✭ ✭ ☆

Please see attached screenshot, that shows my actual value in the Google Spreadsheet.

Yes, I've some custom fields too in data studio.

 actual_data.JPG

 

I have added these two fields as a custom field in Data Studio.

I am using formula: TODATE(Start Date, 'DEFAULT_DASH', "%Y-%m") in Month Year field, as a workaround option and that displays value as 2017-03 in bar chart, however I need that in format March 2017.

 

Fields.JPG

Current month shows previous month

Follower ✭ ✭ ☆
# 9
Follower ✭ ✭ ☆

I would like to know if there is any solution here?

Re: Current month shows previous month

Explorer ✭ ✭ ☆
# 10
Explorer ✭ ✭ ☆

@Kunal P

 

I did a test and i don't have your problem. I got the good values in the right months. 

 

The data source.

 

kunal.PNG

Charts and fields

kunalField.PNGKunaldata.png

 

Don't know why you have set your field Year Month in text... 

 

Maybe your problem is coming from the format date in your spreadsheet.