Skip to Content
avatar image
Former Member

Design Studio - Plot Time Measure On Y-Axis With Line Chart

Hello Experts,

What I’m attempting to do is create a line chart that maps the time of day a particular batch job starts across a given date range. So the X-Axis is date, the Y-Axis is time (the data source has a 24 hour time format, but AM/PM would be fine too). I am loading a data source from a BEx query that provides the desired data. The name and date are attributes that function as expected. The time key figure (measure) however, loads as expected to the data source, it is displayed as expected in the crosstabs, but it will not plot on a chart. We are running Design Studio Release 1.6. Please advise if there is a way to get the time measure to plot as I am looking for it on this requirement as well as several others for our organization.

In the below screenshot you can see the default info chart (line chart) that Design Studio creates when loaded with the data source containing a Time key figure as the measure. You can see that by default it charts the date correctly along the X-Axis, but then puts decimals between 0 and 1.2 on the Y-Axis. My expectation would be the Y-Axis should contain a measure of time. Below the chart is a crosstab from the same data source as the chart so that you can see the data points that should be plotted. Notice NOTHING is plotted on the chart.

In the next screenshots you can see that I changed the format of the Y-Axis to force it into a time format to match the time format in the data source. It did format the Y-Axis as a 24 hour clock, but still nothing is plotted.

Below is a screenshot of the initial view of the data source. I have filtered the number of ‘job names’ and the date range just for the sake of a smaller dataset to present for example.

Finally, here’s an example of what I would expect the chart to look like. Or something similar to this (done in excel).

dn7sj.jpeg (16.2 kB)
ybonk.jpeg (16.6 kB)
fru8o.png (15.6 kB)
ogkm4.jpeg (31.9 kB)
zseus.png (82.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 09, 2017 at 08:32 PM

    Hi Ian,

    Thank you for taking the time to document the issue.

    Only thing I could find is this thread https://answers.sap.com/questions/89325/how-to-display-seconds-in-timestamp-format-hhmmss.html where the conclusion was that Design Studio doesn't like the measure as a format. Web Intelligence seems OK with it (according to the thread) so perhaps that is an option?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Mustafa Bensan

      Mustafa,

      You're awesome! Thank you for giving this so much thought.

      I'm probably going to have to table this issue for a little while as it has become a little more of a time sink than I had hoped. And other priorities are calling! I will come back and update this thread whenever we have the time to give it a little more attention though.

      Thanks again for all your help...

      Sincerely,

      Ian