# Kibana JSON input - String manipulation
**URL:** https://discuss.elastic.co/t/kibana-json-input-string-manipulation/68435
**Category:** Kibana
**Created:** [December 8, 2016, 12:39pm UTC](https://discuss.elastic.co/t/kibana-json-input-string-manipulation/68435 "2016-12-08T12:39:38Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Alex\_Buys](https://discuss.elastic.co/u/Alex_Buys)
#### Post date: [December 8, 2016, 12:39pm UTC](https://discuss.elastic.co/t/kibana-json-input-string-manipulation/68435/1 "2016-12-08T12:39:38Z")
I am trying to build a visualization on Kibana to display data per day of the week. In other words, count of transactions for Monday, Tuesday, Wednesday, etc. over a duration.
I tried variations on the following JSON input filter on a histogram graph but nothing seemed to work:
```
{
"script": "doc['@timestamp'].value.date.dayOfWeek().getAsText()"
}
```
I read somewhere that Kibana can't preform term aggregations on strings (only on numbers). Is this true?
Is it possible to retrieve the day of the week from a timestamp as depicted above in Kibana (I don't have access to ElasticSearch or logstash so I can't manipulate the data at those ends).
Using the latest version of Kibana
---
### Author:  [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)
#### Post date: [December 9, 2016, 1:46am UTC](https://discuss.elastic.co/t/kibana-json-input-string-manipulation/68435/2 "2016-12-09T01:46:20Z")
Hey Alex,
Create a scripted field under the index pattern at `Management > Index Patterns`
name; `dow`
script: `doc['@timestamp'].date.dayOfWeek`
You can then use the `dow` in term aggregations. It will be an integer, but you could further enhance the script to return the name of the week.
---
### Author:  [@Alex\_Buys](https://discuss.elastic.co/u/Alex_Buys)
#### Post date: [December 9, 2016, 7:36am UTC](https://discuss.elastic.co/t/kibana-json-input-string-manipulation/68435/3 "2016-12-09T07:36:24Z")
Thank you - this solved my problem
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 6, 2017, 7:36am UTC](https://discuss.elastic.co/t/kibana-json-input-string-manipulation/68435/4 "2017-01-06T07:36:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.