Measures
In-app master measures.
Page contents:
List master item measures in a Sense app
.\ctrl-q.exe master-item-measure-get `
--host pro2-win1.lab.ptarmiganlabs.net `
--auth-user-dir LAB `
--auth-user-id goran `
--app-id a3e0f5d2-000a-464f-998d-33d333b175d7 `
--output-format table
2024-03-12T08:38:15.661Z info: -----------------------------------------------------------
2024-03-12T08:38:15.661Z info: | Ctrl-Q
2024-03-12T08:38:15.661Z info: |
2024-03-12T08:38:15.661Z info: | Version : 3.16.0
2024-03-12T08:38:15.661Z info: | Log level : info
2024-03-12T08:38:15.661Z info: |
2024-03-12T08:38:15.661Z info: | Command : master-item-measure-get
2024-03-12T08:38:15.661Z info: | : get info about one or more master measures
2024-03-12T08:38:15.661Z info: |
2024-03-12T08:38:15.661Z info: | Run Ctrl-Q with the '--help' option to see a list of all available options for this command.
2024-03-12T08:38:15.661Z info: |
2024-03-12T08:38:15.661Z info: | https://github.com/ptarmiganlabs/ctrl-q
2024-03-12T08:38:15.661Z info: ----------------------------------------------------------
2024-03-12T08:38:15.661Z info:
2024-03-12T08:38:15.676Z info: Get master measures
2024-03-12T08:38:16.191Z info:
┌────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ Measures (4 measure(s) found in the app) │
├──────────────────────────────────────┬─────────┬────────────────────────┬───────────────────────────────────────────────────┬──────────────────┬──────────────────┬──────────────────────┬──────────────────────────────────────────────────────────────────────────────────────────────────────┬───────────────────────────────────────┬──────────┬──────────┬───────────┬──────────────────────────┬──────────────────────────┬──────────────────────────┬───────────┬───────────┤
│ Id │ Type │ Title │ Description │ Label │ Label expression │ Definition │ Coloring │ Number format │ Grouping │ Approved │ Published │ Publish time │ Created date │ Modified date │ Owner │ Tags │
├──────────────────────────────────────┼─────────┼────────────────────────┼───────────────────────────────────────────────────┼──────────────────┼──────────────────┼──────────────────────┼──────────────────────────────────────────────────────────────────────────────────────────────────────┼───────────────────────────────────────┼──────────┼──────────┼───────────┼──────────────────────────┼──────────────────────────┼──────────────────────────┼───────────┼───────────┤
│ 0a4151cf-0b3d-423d-84d7-eb18ff4ce07a │ measure │ Profit EUR │ Profit during selected time period. │ ='Profit' │ ='Profit' │ Sum(Profit) │ │ {"qType":"U","qnDec":10,"qUseThou":0} │ N │ false │ false │ 1753-01-01T00:00:00.000Z │ 2023-05-09T18:48:43.431Z │ 2023-06-05T18:39:32.990Z │ LAB\goran │ Sales │
├──────────────────────────────────────┼─────────┼────────────────────────┼───────────────────────────────────────────────────┼──────────────────┼──────────────────┼──────────────────────┼──────────────────────────────────────────────────────────────────────────────────────────────────────┼───────────────────────────────────────┼──────────┼──────────┼───────────┼──────────────────────────┼──────────────────────────┼──────────────────────────┼───────────┼───────────┤
│ 9d563fc2-ad00-41db-ad15-0f80c522686d │ measure │ Revenue EUR (LY) │ Revenue during last year. │ ='Revenue LY' │ ='Revenue LY' │ Sum(Revenue_LY) │ │ {"qType":"U","qnDec":10,"qUseThou":0} │ N │ false │ false │ 1753-01-01T00:00:00.000Z │ 2023-05-09T15:18:20.753Z │ 2023-05-09T15:40:12.804Z │ LAB\goran │ Sales, LY │
├──────────────────────────────────────┼─────────┼────────────────────────┼───────────────────────────────────────────────────┼──────────────────┼──────────────────┼──────────────────────┼──────────────────────────────────────────────────────────────────────────────────────────────────────┼───────────────────────────────────────┼──────────┼──────────┼───────────┼──────────────────────────┼──────────────────────────┼──────────────────────────┼───────────┼───────────┤
│ a260c5a2-21e9-4ce5-92d9-c3e7837e51a2 │ measure │ No. of sold units (LY) │ Number of units sold last year. │ ='Sold units LY' │ ='Sold units LY' │ Sum(UnitsInOrder_LY) │ Measure color: │ {"qType":"U","qnDec":10,"qUseThou":0} │ N │ false │ false │ 1753-01-01T00:00:00.000Z │ 2023-05-09T15:18:20.753Z │ 2023-05-09T15:40:12.804Z │ LAB\goran │ Sales, LY │
│ │ │ │ │ │ │ │ {"color":"#8a85c6","index":8} │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
├──────────────────────────────────────┼─────────┼────────────────────────┼───────────────────────────────────────────────────┼──────────────────┼──────────────────┼──────────────────────┼──────────────────────────────────────────────────────────────────────────────────────────────────────┼───────────────────────────────────────┼──────────┼──────────┼───────────┼──────────────────────────┼──────────────────────────┼──────────────────────────┼───────────┼───────────┤
│ 94631826-88b0-4e84-bf71-9667972e8f15 │ measure │ No. of sold units │ Number of units sold during selected time period. │ ='Sold units' │ ='Sold units' │ =Sum(UnitsInOrder) │ Measure color: │ {"qType":"U","qnDec":10,"qUseThou":0} │ N │ false │ false │ 1753-01-01T00:00:00.000Z │ 2023-05-09T18:48:43.431Z │ 2023-06-05T18:39:32.990Z │ LAB\goran │ Sales │
│ │ │ │ │ │ │ │ {"color":"#8a85c6","index":8} │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ Segment colors: │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ {"colors":[{"color":"#006580","index":6},{"color":"#ac4d58","index":10},{"color":"#4477aa","index":- │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ 1},{"color":"#7db8da","index":-1}],"breakTypes":[true,true,false],"limits":[0.223,0.491,0.728],"limi │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ tType":"percent"} │ │ │ │ │ │ │ │ │ │
└──────────────────────────────────────┴─────────┴────────────────────────┴───────────────────────────────────────────────────┴──────────────────┴──────────────────┴──────────────────────┴──────────────────────────────────────────────────────────────────────────────────────────────────────┴───────────────────────────────────────┴──────────┴──────────┴───────────┴──────────────────────────┴──────────────────────────┴──────────────────────────┴───────────┴───────────┘
Delete master item measures in a Sense app
.\ctrl-q.exe master-item-measure-delete `
--host pro2-win1.lab.ptarmiganlabs.net `
--app-id a3e0f5d2-000a-464f-998d-33d333b175d7 `
--auth-user-dir LAB `
--auth-user-id goran `
--id-type name `
--master-item 'Revenue EUR' 'Profit EUR (LY)'
2024-03-12T08:38:49.705Z info: -----------------------------------------------------------
2024-03-12T08:38:49.705Z info: | Ctrl-Q
2024-03-12T08:38:49.705Z info: |
2024-03-12T08:38:49.705Z info: | Version : 3.16.0
2024-03-12T08:38:49.705Z info: | Log level : info
2024-03-12T08:38:49.705Z info: |
2024-03-12T08:38:49.705Z info: | Command : master-item-measure-delete
2024-03-12T08:38:49.705Z info: | : delete master measure(s)
2024-03-12T08:38:49.719Z info: |
2024-03-12T08:38:49.719Z info: | Run Ctrl-Q with the '--help' option to see a list of all available options for this command.
2024-03-12T08:38:49.719Z info: |
2024-03-12T08:38:49.719Z info: | https://github.com/ptarmiganlabs/ctrl-q
2024-03-12T08:38:49.719Z info: ----------------------------------------------------------
2024-03-12T08:38:49.719Z info:
2024-03-12T08:38:49.719Z info: Delete master measures
2024-03-12T08:38:50.188Z info: (1/2) Deleted master item measure "Revenue EUR", id=5a166d1d-b873-4fbf-b4fa-9b38cb271d54 in app "a3e0f5d2-000a-464f-998d-33d333b175d7"
2024-03-12T08:38:50.188Z info: (2/2) Deleted master item measure "Profit EUR (LY)", id=a9f885bd-9648-4216-8faa-c895bbf9d6b7 in app "a3e0f5d2-000a-464f-998d-33d333b175d7"
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.
Last modified March 12, 2024: 3.16.0 update (3528ed7)