The first column is not sorted as shown in the myDBR table

(5 posts) (2 voices)

Tags:

No tags yet.

  1. jasmondluk, Member


    select 'DBR.text' as 'DBR.text', 'Eye Level Interactive Education Centre (Discovery Park),Gift Icon Education Centre (Papillons Square)' as 'group_concat( centername )'; select 'dbr.text', 'From: 2022-01-01 to 2022-01-31';
    select 'dbr.crosstab', 'Month';
    select 'dbr.sum', '[Income]';
    select 'dbr.hsum', '[Income]';
    select 'dbr.summary.text', 'Course', 'Total';
    select 'dbr.search', 1;
    select 'dbr.subtitle', 'Monthly Revenue By Subject';
    select 'dbr.sort', 'Course';
    select 'dbr.export.options', 'autosize', 1; select 'Eye Level Interactive Education Centre (Discovery Park)' as 'Center', '(Sun) English' as 'Course', '7 Eng' as 'Code', '2022-01' as 'Month', 5643.0 as '[Income]'
    union all
    select 'Eye Level Interactive Education Centre (Discovery Park)', '(Sun) Mathematics', '7 Math', '2022-01', 12011.0
    union all
    select 'Eye Level Interactive Education Centre (Discovery Park)', '(Sun) Sparks', '7 SPK', '2022-01', 2403.0
    union all
    select 'Eye Level Interactive Education Centre (Discovery Park)', 'Active Writers', 'R AW', '2022-01', 6995.0
    union all
    select 'Eye Level Interactive Education Centre (Discovery Park)', 'English', 'R Eng', '2022-01', 35850.0
    union all
    select 'Eye Level Interactive Education Centre (Discovery Park)', 'Grammar', 'R Gmar', '2022-01', 1250.0
    union all
    select 'Eye Level Interactive Education Centre (Discovery Park)', 'Mathematics', 'R Math', '2022-01', 73459.5
    union all
    select 'Eye Level Interactive Education Centre (Discovery Park)', 'Sparks', 'R SPK', '2022-01', 23400.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Abacus', 'Abacus', '2022-01', 1096.666667
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Cambridge English', 'CE', '2022-01', 2716.666667
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Drama Course (Sat)', 'DramaSat', '2022-01', 1400.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Eliteracy', 'ELITE', '2022-01', 300.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Eliteracy (30 mins)', 'ELITE 30', '2022-01', 127.5
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'EnglishX', 'ENGX', '2022-01', 765.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Homework Class', 'HC', '2022-01', 3714.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Iconic Math', 'MATH', '2022-01', 450.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'SEN Training (Miss Ho)', 'Miss Ho', '2022-01', 1012.666667
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Oil painting', 'OilP', '2022-01', 0.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Oral 447', 'ORAL', '2022-01', 1740.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'SEN Training', 'SEN T', '2022-01', 1125.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'SEN 功輔 3小時', 'SEN 功輔', '2022-01', 2742.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'SEN功輔 1.5 小時', 'SEN功輔', '2022-01', 2042.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Sketching', 'sketch', '2022-01', 0.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'SuPhonics', 'SPHON', '2022-01', 300.0
    union all
    select 'Gift Icon Education Centre (Papillons Square)', 'Writing Warriors', 'WRTW', '2022-01', 2856.0; select 'dbr.chart', 'Pie3D', 'Revenue by Course', 800, 500; select 'dbr.colstyle', 1, 't';
    select 'dbr.colstyle', 2, '{label}
    {percent}%'; select 'Sparks' as 'Course', 23400.0 as '[Income]'
    union all
    select 'Mathematics', 73459.5
    union all
    select 'English', 35850.0
    union all
    select '(Sun) Mathematics', 12011.0
    union all
    select '(Sun) English', 5643.0
    union all
    select '(Sun) Sparks', 2403.0
    union all
    select 'Active Writers', 6995.0
    union all
    select 'Grammar', 1250.0
    union all
    select 'Writing Warriors', 2856.0
    union all
    select 'Iconic Math', 450.0
    union all
    select 'SEN Training', 1125.0
    union all
    select 'Sketching', 0.0
    union all
    select 'EnglishX', 765.0
    union all
    select 'SEN Training (Miss Ho)', 1012.666667
    union all
    select 'Oil painting', 0.0
    union all
    select 'SEN 功輔 3小時', 2742.0
    union all
    select 'Homework Class', 3714.0
    union all
    select 'Cambridge English', 2716.666667
    union all
    select 'Eliteracy (30 mins)', 127.5
    union all
    select 'Oral 447', 1740.0
    union all
    select 'SEN功輔 1.5 小時', 2042.0
    union all
    select 'SuPhonics', 300.0
    union all
    select 'Abacus', 1096.666667
    union all
    select 'Eliteracy', 300.0
    union all
    select 'Drama Course (Sat)', 1400.0;

  2. myDBR Team, Key Master

    Can you elaborate what do you mean by "first column is not sorted as shown"? Does it not sort at all or is the sorting order wrong?

    Are you referring to the first crosstable resultset?

    The first column should sort as expected.
    --
    myDBR Team

  3. jasmondluk, Member

    Yes it is not sorted. You can see the image in https://dreamware.click/mydbr1.png

  4. myDBR Team, Key Master

    Hi,
    you have set the sorting to be based on the Course-column:

    select 'dbr.sort', 'Course';

    The Course-column is sorted alphabetically (parentheses are sorted before letters).

    --
    myDBR Team

  5. jasmondluk, Member

    got it. Thanks.


Reply

You must log in to post.