# Visualizations combinations **URL:** \ **Category:** Elasticsearch\ **Created:** [June 2, 2020, 1:15am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262 "2020-06-02T01:15:46Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![kumar\_k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar_k/32/50877_2.png) [@kumar\_k](https://discuss.elastic.co/u/kumar_k)\ **Post date:** [June 2, 2020, 1:15am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/1 "2020-06-02T01:15:46Z")
I want to visualize electric load profile weekly wise. The electric load profile has the electric load readings taken for every hour on each day. Typical CSV columns are date,day,hour,load. In a day 24 readings are taken, in a week (7 multiplied by 24)=168 and in a month (168 multiplied by 4)=672 are taken. So there are around 700 rows for a typical month. I want to have visualizations for weekly wise, day wise, hour range wise etc., As of now I am just using only two columns with serial number and load. And two visualizations I made. One as x axis serial number from 1 to 700. And y axis as load. Second as x axis load and y axis as count. How to have different combinations of visualizations for day wise and hour wise. I am using python client to create elasticsearch object and using CSV reader to read the file and populate elasticsearch object. Please guide me. thanks, ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 2, 2020, 1:21am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/2 "2020-06-02T01:21:08Z")
What does your data structure look like? ---
**Author:** ![kumar\_k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar_k/32/50877_2.png) [@kumar\_k](https://discuss.elastic.co/u/kumar_k)\ **Post date:** [June 2, 2020, 1:36am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/3 "2020-06-02T01:36:36Z")
Hi Warkolm, The data structure looks like below. Date,day,hour,load in kW 1st April 2019,Monday,1 AM,50 1st April 2019, monday,2 AM,72 . . 1st April 2019,Monday,9 AM,200 . . 1st April 2019,Monday,11pm,55 2nd April 2019,Tuesday,1 Am,45 . . . 31st April 2019, Wednesday,1 AM,57 . . .. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 2, 2020, 1:38am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/4 "2020-06-02T01:38:19Z")
And what does it look like in Elasticsearch? ---
**Author:** ![kumar\_k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar_k/32/50877_2.png) [@kumar\_k](https://discuss.elastic.co/u/kumar_k)\ **Post date:** [June 2, 2020, 1:45am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/5 "2020-06-02T01:45:01Z")
Since I don't know how to show date and day in visualization I made CSV with two columns serial number,load because they are numbers. I know only to create visualization with numbers. I created one histogram with x axis as serial nbr and y axis as load. Second visualization I made with count as y axis and x axis as load. So I can see one particular load how many times occurred in a month. ![IMG-20200601-WA0008](https://us1.discourse-cdn.com/elastic/original/3X/c/7/c7e4e7729ad3efd9f25344608f233767f7e767b7.jpeg) ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 2, 2020, 1:46am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/6 "2020-06-02T01:46:01Z")
How are you loading this data into Elasticsearch? You should really be converting the date, day and hour into a single timestamp field. ---
**Author:** ![kumar\_k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar_k/32/50877_2.png) [@kumar\_k](https://discuss.elastic.co/u/kumar_k)\ **Post date:** [June 2, 2020, 1:49am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/7 "2020-06-02T01:49:35Z")
Ok Warkolm. Then I have to find how to write python client code for creating timestamp and populate that into elasticsearch object. So you mean to say I will have only two columns ? Timestamp, load. Is my understanding correct ? What is the visualization then for this kind of data structure ? ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 2, 2020, 1:51am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/8 "2020-06-02T01:51:38Z")
Ideally you would have those, yes, plus the source of the data (which I guess is a meter?). That way you can do changes over time using line/bar graphs and separate by source. ---
**Author:** ![kumar\_k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar_k/32/50877_2.png) [@kumar\_k](https://discuss.elastic.co/u/kumar_k)\ **Post date:** [June 2, 2020, 1:57am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/9 "2020-06-02T01:57:02Z")
Sorry, I didn't understand. So should I have data structure like this ? Date, day, time, Timestamp, load in kilowatts. Could you point me to some documentation explaining visualizations having Timestamp and also data having non number data. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 2, 2020, 2:01am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/10 "2020-06-02T02:01:56Z")
Like this; ```auto { "timestamp" : value, "reading": value, "source": value } ``` If this is in CSV, then you can easily ingest it using Beats or Logstash, without having to write your own code from scratch. ---
**Author:** ![kumar\_k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar_k/32/50877_2.png) [@kumar\_k](https://discuss.elastic.co/u/kumar_k)\ **Post date:** [June 2, 2020, 2:09am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/11 "2020-06-02T02:09:04Z")
Condemn my less intelligence in elasticsearch ... ☹ I feel I have to work more on understanding beats and logstash and how to interpret data structure in relation to elasticsearch. By the bye, what do you mean by "source" ? I understood "reading" which is electrical load. But what is the "source" which you are mentioning ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 2, 2020, 2:10am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/12 "2020-06-02T02:10:46Z")
No worries! Regarding source; I am guessing that you have load readings from different sources? ---
**Author:** ![kumar\_k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar_k/32/50877_2.png) [@kumar\_k](https://discuss.elastic.co/u/kumar_k)\ **Post date:** [June 2, 2020, 2:15am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/13 "2020-06-02T02:15:06Z")
Thank you warkolm. The "load" value taken from an electric meter hourly basis manually by from the meter display. This is the single source for me. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 2, 2020, 2:15am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/14 "2020-06-02T02:15:42Z")
Ok. I was just thinking you may want to be able to differentiate if you end up with multiple different sources, but sounds like it's not relevant. ---
**Author:** ![kumar\_k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar_k/32/50877_2.png) [@kumar\_k](https://discuss.elastic.co/u/kumar_k)\ **Post date:** [June 2, 2020, 2:20am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/15 "2020-06-02T02:20:06Z")
Yeah. Multiple sources of data as of now not there. But good that you have given valuable insight what if there are multiple sources of data. I will have to explain this. Could you point me to some visualization involving timestamp. I am having little difficulty in understanding how a timestamp actually appears in a typical visualization. Because I always assume visualization means only numbers on x axis and y axis. Eager to know how timestamp appears in a visualization. Thanks ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [June 2, 2020, 2:21am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/16 "2020-06-02T02:21:17Z")
[https://www.elastic.co/guide/en/kibana/current/most-frequent.html](https://www.elastic.co/guide/en/kibana/current/most-frequent.html) for eg. Also take a look at [our blog](https://www.elastic.co/blog/), there are tonnes of examples from ourselves and our users. ---
**Author:** ![kumar\_k](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar_k/32/50877_2.png) [@kumar\_k](https://discuss.elastic.co/u/kumar_k)\ **Post date:** [June 2, 2020, 2:54am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/17 "2020-06-02T02:54:48Z")
Thanks warkolm for your mini tutorial in this post. I will go through the blog and the examples. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 30, 2020, 2:55am UTC](https://discuss.elastic.co/t/visualizations-combinations/235262/18 "2020-06-30T02:55:04Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.