Skip to Main Content
ARIS - SHARE YOUR IDEAS
How can we make ARIS better?
Status Open for voting
Workspace Dashboarding
Created by Monika Leitner
Created on Jan 5, 2022

Totals, subtotals are only supported via RAQL

Dear all,

Currently ARIS Aware / Mashzone NG supports totals or subtotals (on columns and rows) are only supported using RAQLs.

Example sums over organisation

select nvl(Organisation,'Total') Organisation,
sum(CASE WHEN Sparte= 'KFZ' THEN Anzahl_Retourengruende ELSE 0.0 END) as Anzahl_KFZ
,
sum(CASE WHEN Sparte= 'Leben' THEN Anzahl_Retourengruende ELSE 0.0 END) as Anzahl_Leben
,
sum(CASE WHEN Sparte= 'SHU NKS' THEN Anzahl_Retourengruende ELSE 0.0 END) as Anzahl_SHU_NKS
,
sum(CASE WHEN Sparte= 'Unfall' THEN Anzahl_Retourengruende ELSE 0.0 END) as Anzahl_Unfall,
sum (Anzahl_Retourengruende) as Gesamt
from feed1
group by rollup (Organisation)

Please support an easier way without RAQL


Brainstorm ID 6460
Created on Brainstorm 11/15/2018 06:04 AM
  • +5