Skip to Content
author's profile photo Former Member
Former Member

Filtered and non-filtered values in the same chart?

I have a data set related to service desk tickets.

At a high level it looks like this:

Incident ID

Created Date

Status

Resolved Date

There are other fields but for my purposes those are the big ones.

From there I've created a variable that counts the number of incidents. I can use it to accurately count incidents created on a day, resolved on a day, incidents with a certain status, etc.

However, they want a dual line chart showing incidents opened AND incidents closed, day by day, in the same chart.

From what I can tell in Webi, there's no way to do this in the same chart. I have literally tried everything, every variable, filter, etc. that I can think of.

Is it possible to do or should I quit trying? It seems like something that should be pretty simple to do, and in BEx I would just create a restricted key figure. But not sure how to do that here?? I also am unable to display the values in the same table, etc (which I would also like to do). Any advice?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2014 at 02:56 PM

    Hi,

    You create the variable in the below logic.

    Va_Count=Count(Incident) In ([Date object];[Status object])

    This will give the number of incident for each day for every status. if you want to know the exact day wise just create the section by date.

    the chart as follow: x-Axis (Date), Y-Axis (Status) and data is your derived variable (Var_count)

    Thanks,

    sakthi.


    Status Filter.jpg (71.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 02:24 PM

    Not sure it will work or not, but you can try it:

    Create one query in webi with created date and incident. From this you can create a measure to get incident count opened by date.

    In the same report, create another query with resolved date and incident. From this you can get count of incidents resolved by date.

    Now merge created date and resolved date in webi and use that merged dimension along with the measure variables.

    Try if it works.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 09, 2014 at 04:20 PM

    Hi Kirsten,

    I would go down the route of different RKF's in BEx and then just bring them in as a dimension in your Webi document.

    If your data comes from BEx, you wont have to keep reinventing the wheel with regard to new variables in WebI when you need new documents.

    With regards

    Gill

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.