Grouping by month instead of by full date format

[andrehl]

Hi guys,
Currently, my data is grouped like this:

1. Product | 2018-5-5 02:00  | 2018-5-5 02:30  | 2018-5-5 04:00  |  2018-6-5 02:00
2. asdf  | 5  | 6 |  7 | 5

I want to change my data such that it will group by month

1. Product  |  2018-5  | 2018-6
2. asdf  |  18  |  5

..
This is my code:

index=asdf
|chart eval(round(dc(customers_name) / 74086 * 100,2). "%") by sku_name month

Helpp..

[thambisetty · Accepted solution]

Hi,

You need to create a dummy field to get year and month.

| eval yearMonth=date_year."-".date_month
 |chart eval(round(dc(customers_name) / 74086 * 100,2). "%") by sku_name yearMonth