Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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()))
Hi,
Try like this
Dimension:Category, Date
Expression: Count(Category)/Count(TOTAL <Category> Category)
Hope this helps you.
Regards,
Jagan.
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 ?
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,
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..
Are you looking for this
Category | SalesDate | =Count( SalesDate) |
---|---|---|
9 | ||
Down Call | 01-08-2016 | 4 |
Down Call | 02-08-2016 | 5 |