topic Re: How to use a Gantt Chart in All Apps and Add-ons

How to use a Gantt Chart

harshal_chakran — Mon, 28 Sep 2020 19:12:37 GMT

Hi, I have a CSV file with start_time and end_time and the difference.

Parameters  START_TIME  END_TIME    DIFFERENCE IN MINS
param1        1425485370    1425490179  80.15
param2        1425525368    1425528124  45.93
param3        1425462452    1425464795  39.05
param4        1425619254    1425620315  17.68

Here the start and end time both are in epoch format.
I want to built a Gantt chart, with Y axis as "Parameters" and X-axis as time over a day.
I have taken help from the Gantt Chart visualization app , but couldn't get through.
I have altered the source code as follows:

<form script="autodiscover.js">
    <label>Gantt Chart demo</label>

    <row>
        <html>
            <h2>Gantt Chart demo</h2>
            <div id="demo-search"
                 class="splunk-manager"
                 data-require="splunkjs/mvc/searchmanager"
                 data-options='{
                    "search": { "type": "token_safe", "value": "|inputcsv myfile.csv |table Parameters, START_TIME END_TIME" },
                    "earliest_time": { "type": "token_safe", "value": "-4h@m" },
                    "latest_time": { "type": "token_safe", "value": "now" },
                    "cancelOnUnload": true,
                    "preview": true
                 }'>
            </div>

            <div id="demo-view"
                 class="splunk-view"
                 data-require="app/gantt/components/gantt/gantt"
                 data-options='{
                    "managerid": "demo-search",
                    "startField": "START_TIME",
                    "endField": "END_TIME",
                    "categoryLabel": "Parameters",
                    "categoryField": "Parameters",
                 }'>
            </div>
        </html>
    </row>
</form>

Please Help...!!

Re: How to use a Gantt Chart

alexiri — Wed, 11 Mar 2015 13:14:38 GMT

What exactly isn't working?

One thing that jumps out while looking at your code is that the categoryField should be Parameters, not Parameter.

Re: How to use a Gantt Chart

harshal_chakran — Wed, 11 Mar 2015 13:25:24 GMT

Hi,
Sorry, It was typing mistake, its "Parameters" only
I am using the source code of the Gantt Chart visualization app. There I have inserted my search query which I mentioned above. And made the changes as per my understanding.
When I save the XML Source Code, no result is displayed.

Re: How to use a Gantt Chart

alexiri — Wed, 11 Mar 2015 13:30:55 GMT

Could it be because of the earliest_time? Perhaps there's actually no data in the last 4 hours. The sample data you sent is several days old, but I don't know if you're working with more data than that...

Re: How to use a Gantt Chart

alexiri — Wed, 11 Mar 2015 13:41:53 GMT

It might also be that there's an extra comma after "categoryField": "Parameters". Splunk's JSON parser is very picky about that sort of thing.

Re: How to use a Gantt Chart

harshal_chakran — Thu, 12 Mar 2015 12:14:52 GMT

Yes, that last comma was the actual problem.
Thanks alexiri. It worked

Re: How to use a Gantt Chart

harshal_chakran — Thu, 12 Mar 2015 12:16:10 GMT

I have changed the earlier and latest according to my data timestamp.

Re: How to use a Gantt Chart

sssignals — Wed, 01 Nov 2017 09:24:37 GMT

Hi harshal_chakranarayan,

I faced a similar problem as you. Did your above example work? The gantt example makes use of events and transaction which is not directly applicable. I am trying to get an example like yours to work.

Thanks.