Timeline for I want to add Sub Total using SAQL Query
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 18, 2022 at 10:10 | answer | added | Darshika Verma | timeline score: 0 | |
| Mar 18, 2022 at 9:35 | comment | added | Darshika Verma | But the above query doesn't give me the right output | |
| Mar 18, 2022 at 9:34 | comment | added | Darshika Verma | q = load "Issuance1"; q = group q by rollup ('Region','Sector','SalesComments'); q = foreach q generate case when grouping('Region') == 1 then "Total" else 'Region' end as 'Region', case when grouping('Sector') == 1 then "Subtotal" else 'Sector' end as 'Sector', case when grouping('SalesComments') == 1 then "" else 'SalesComments' end as 'SalesComments', count() as 'count'; q = order q by ('Region' asc, 'Sector' asc,'SalesComments' asc); q = limit q 2000; | |
| Mar 18, 2022 at 9:34 | comment | added | Darshika Verma | @FelixvanHove yes, I have implemented it. | |
| Mar 17, 2022 at 17:26 | comment | added | Felix van Hove | Hey, have you made an attempt to write this SAQL query? Or have you just got a requirement and want someone from Salesforce Stack Exchange to implement it for you? Sorry to say, but this is not the idea of this site. | |
| Mar 17, 2022 at 14:46 | review | Close votes | |||
| Apr 2, 2022 at 3:04 | |||||
| Mar 17, 2022 at 14:32 | history | edited | Adrian Larson♦ |
edited tags
|
|
| S Mar 17, 2022 at 14:23 | review | First questions | |||
| Mar 17, 2022 at 17:27 | |||||
| S Mar 17, 2022 at 14:23 | history | asked | Darshika Verma | CC BY-SA 4.0 |