Flag for Pie chart

[soniasweety]

Hi all,

Tresesco B

I want to create a pie chart  with the bucket values like below

0-7 days

7-14 days

14-30 days

30-60 days

so I want this from  "updated date column"

I don't have master calendar . And I need result in days.

[devarasu07]

Hi,

It should work, can you share you app? .

may be you can try to apply date format in back end script and try again.

like this

Date([Open Date]) as [Open Date],

Date([Update Time]) as [Update Time],

[soniasweety]

still the same issue 1900 year coming after changing the date format

[devarasu07]

Can you share your app?

[soniasweety]

attaching sample app ,

check the age column values in my app

[devarasu07]

Hi,

check the attached,

note: back end script i've commented out few column it's not there in your uploaded source flag file

[soniasweety]

still the same it is showing   

[soniasweety]

what is the change I need to do in this?    I replaced the age column still same values showing in the filter

[devarasu07]

hi,

ServiceRequest:

load *, if( (age) >=0 and (age) <7 , '0-7 days',

    if( (age) >=7 and (age) <14, '7-14 days',

    if( (age) >=14 and (age) <30, '14-30 days',

    if( (age) >=30 and (age) <60, '30-60 days')))) as Aging_Slab;

LOAD

    "Change ID",

    Category,

    "Sub-area",

    Status,

    "Assignment Group",

     date( "Open Date") as "Open Date",

     month([Open Date]) as Month,

     year([Open Date]) as Year,

     date([Open Date]) as Date,

     Day([Open Date]) As Day,

    round(now()-[Open Date],0.01) as TimeLefttoBreachSLA,

    Date([Close Time],'M/DD/YYYY') as [Close Time],

    Title,

    Assignee,

    Date([Update Time],'M/DD/YYYY') as [Update Time],

     Interval(Date([Update Time])-Date([Open Date]),'dd') as age,

     "Update Actions",

    "SLA Breach"

FROM [lib://DataSource/Data\requests extract.xlsx]

(ooxml, embedded labels, table is cm3r1500445944654)

[soniasweety]

still no use.

[devarasu07]

Hi,

Can you share your "requests extract.xlsx" file

do simple steps

1)

try to import your excel file into qliksense

2) add preceding load

like this,

load *, if( (age) = 0, '0',

    if( (age) >=0 and (age) <7 , '0-7 days',

    if( (age) >=7 and (age) <14, '7-14 days',

    if( (age) >=14 and (age) <30, '14-30 days',

        if( (age) >=30 and (age) <60, '30-60 days'))))) as Aging_Slab;    

Load *, Interval(Date([Update Time])-Date([Open Date]),'dd') as age;

load *

FROM [lib://DataSource/Data\requests extract.xlsx]

(ooxml, embedded labels, table is cm3r1500445944654)

Buckets

that's all.

thanks,deva