I want to calculate per day category wise data

[#1]

Hello All,

Stuck in this way menace thing,

I have a excel in which everyday tickets are getting logged, I have to calculate this tickets on per day basis

ex

Date               Category

01-08-2016      Down Call

01-08-2016      Down Call

01-08-2016      Down Call

01-08-2016      Down Call

02-08-2016      Down Call

02-08-2016      Down Call@

02-08-2016      Down Call

02-08-2016      Down Call

02-08-2016      Down Call

Now I have to Calculate on per day like category=''Down Call' and count on single date ex 01 was 4 then adding this with date 02 i.e.

so total would be 9.

I will be dividing the end result with the total no. of devices I have, So that I can have a percentage score for performance evaluation on daily basis for a whole month

[rupamjyotidas]

Are you looking to accumulate. I didn't get your question. Maybe a sample can help

but accumulation in Qliksense can be done by rangesum and above()

rangesum( above( sum([Expression1]),0,rowno()))

[jagan]

Hi,

Try like this

Dimension:Category, Date

Expression: Count(Category)/Count(TOTAL <Category> Category)

Hope this helps you.

Regards,

Jagan.

[varshavig12]

for the first part:

i.e.

Now I have to Calculate on per day like category=''Down Call' and count on single date ex 01 was 4 then adding this with date 02 i.e.

so total would be 9.

What output are you expecting for the second part ?

[Anonymous]

Use Aggr(RangeSum(above(Count(Category),0,RowNo())),Date1) for following result in 4th column.

Date1	Category	Count(Category)	Aggr(RangeSum(above(Count(Category),0,RowNo())),Date1)
Total		9
01-08-2016	Down Call	4	4
02-08-2016	Down Call	5	9

Thanks,

[#6]

it should be come as grand total on a KPI visual per day ticket counts could be 3100 and next day if 5 tickets are resolved than 3095 so it should add like 3100+3095 and so on..

[Anonymous]

Are you looking for this

Category	SalesDate	=Count( SalesDate)
		9
Down Call	01-08-2016	4
Down Call	02-08-2016	5