Skip to main content

Dear Experts, I would like to create an unsorted index on an OLAP table in the Analytics new sheet.

I'm use pql

dimension

  1. INDEX_ORDER (COUNT (DISTINCT "table"."column"))
  2. "table"."caseid"

kpi

count("table"."caseid")

now If I sort case count, ​Indexes and case IDs are turned into a set.

I want the index value to not change even if I sort by case count.

ex)

index | caseid | case count

1 | A | 3

2 | B | 2

3 | C | 1

 

​sorting ->

 

  • ​now

index | caseid | case count (sort)

3 | C | 1

2 | B | 2

1 | A | 3

 

  • Goal

index | caseid | case count (sort)

1 | C | 1

2 | B | 2

3 | A | 3

-> This is my goal

Hi there,

 

try this:

RUNNING_SUM ( COUNT(1) )

 

Does it solve your issue?

 

Kind Regards

Alex


Hi there,

 

try this:

RUNNING_SUM ( COUNT(1) )

 

Does it solve your issue?

 

Kind Regards

Alex

Thank you for answer.

 

but my problem is not solved

I wanted this function because I wanted to count the number when sorting in an OLAP table like excel.

For example, if there are 50 rows, when desacending the casecount, I wanted to make it possible to see the index and think that there are 10 rows without counting the top 10.

Still, it was good to have time to study about running_sum, which I didn't know about. If you think of a new method, please leave a comment.

 

thank you. :D


Thank you for answer.

 

but my problem is not solved

I wanted this function because I wanted to count the number when sorting in an OLAP table like excel.

For example, if there are 50 rows, when desacending the casecount, I wanted to make it possible to see the index and think that there are 10 rows without counting the top 10.

Still, it was good to have time to study about running_sum, which I didn't know about. If you think of a new method, please leave a comment.

 

thank you. :D

You know, just in case you didn't know, I'll also leave the method I tried index order()


Reply