You are here

views.view.sales_report.yml in Commerce Reporting 8

config/install/views.view.sales_report.yml

File

config/install/views.view.sales_report.yml
View source
  1. langcode: en
  2. status: true
  3. dependencies:
  4. module:
  5. - commerce
  6. - commerce_reports
  7. - user
  8. id: sales_report
  9. label: 'Sales report'
  10. module: views
  11. description: ''
  12. tag: ''
  13. base_table: commerce_order_report
  14. base_field: report_id
  15. core: 8.x
  16. display:
  17. default:
  18. display_plugin: default
  19. id: default
  20. display_title: Master
  21. position: 0
  22. display_options:
  23. access:
  24. type: perm
  25. options:
  26. perm: 'access commerce reports'
  27. cache:
  28. type: tag
  29. options: { }
  30. query:
  31. type: views_query
  32. options:
  33. disable_sql_rewrite: false
  34. distinct: false
  35. replica: false
  36. query_comment: ''
  37. query_tags: { }
  38. exposed_form:
  39. type: basic
  40. options:
  41. submit_button: Apply
  42. reset_button: false
  43. reset_button_label: Reset
  44. exposed_sorts_label: 'Sort by'
  45. expose_sort_order: true
  46. sort_asc_label: Asc
  47. sort_desc_label: Desc
  48. pager:
  49. type: none
  50. options:
  51. offset: 0
  52. style:
  53. type: table
  54. row:
  55. type: fields
  56. fields:
  57. created:
  58. id: created
  59. table: commerce_order_report
  60. field: created
  61. relationship: none
  62. group_type: group
  63. admin_label: ''
  64. label: Date
  65. exclude: false
  66. alter:
  67. alter_text: false
  68. text: ''
  69. make_link: false
  70. path: ''
  71. absolute: false
  72. external: false
  73. replace_spaces: false
  74. path_case: none
  75. trim_whitespace: false
  76. alt: ''
  77. rel: ''
  78. link_class: ''
  79. prefix: ''
  80. suffix: ''
  81. target: ''
  82. nl2br: false
  83. max_length: 0
  84. word_boundary: true
  85. ellipsis: true
  86. more_link: false
  87. more_link_text: ''
  88. more_link_path: ''
  89. strip_tags: false
  90. trim: false
  91. preserve_tags: ''
  92. html: false
  93. element_type: ''
  94. element_class: ''
  95. element_label_type: ''
  96. element_label_class: ''
  97. element_label_colon: true
  98. element_wrapper_type: ''
  99. element_wrapper_class: ''
  100. element_default_classes: true
  101. empty: ''
  102. hide_empty: false
  103. empty_zero: false
  104. hide_alter_empty: true
  105. click_sort_column: value
  106. type: timestamp
  107. settings:
  108. date_format: html_month
  109. custom_date_format: ''
  110. timezone: ''
  111. group_column: value
  112. group_columns: { }
  113. group_rows: true
  114. delta_limit: 0
  115. delta_offset: 0
  116. delta_reversed: false
  117. delta_first_last: false
  118. multi_type: separator
  119. separator: ', '
  120. field_api_classes: false
  121. entity_type: commerce_order_report
  122. entity_field: created
  123. plugin_id: commerce_reports_report_date_field
  124. report_id:
  125. id: report_id
  126. table: commerce_order_report
  127. field: report_id
  128. relationship: none
  129. group_type: count
  130. admin_label: ''
  131. label: '# of Orders'
  132. exclude: false
  133. alter:
  134. alter_text: false
  135. text: ''
  136. make_link: false
  137. path: ''
  138. absolute: false
  139. external: false
  140. replace_spaces: false
  141. path_case: none
  142. trim_whitespace: false
  143. alt: ''
  144. rel: ''
  145. link_class: ''
  146. prefix: ''
  147. suffix: ''
  148. target: ''
  149. nl2br: false
  150. max_length: 0
  151. word_boundary: true
  152. ellipsis: true
  153. more_link: false
  154. more_link_text: ''
  155. more_link_path: ''
  156. strip_tags: false
  157. trim: false
  158. preserve_tags: ''
  159. html: false
  160. element_type: ''
  161. element_class: ''
  162. element_label_type: ''
  163. element_label_class: ''
  164. element_label_colon: true
  165. element_wrapper_type: ''
  166. element_wrapper_class: ''
  167. element_default_classes: true
  168. empty: ''
  169. hide_empty: false
  170. empty_zero: false
  171. hide_alter_empty: true
  172. set_precision: false
  173. precision: 0
  174. decimal: .
  175. separator: ','
  176. format_plural: 0
  177. format_plural_string: !!binary MQNAY291bnQ=
  178. prefix: ''
  179. suffix: ''
  180. click_sort_column: value
  181. type: number_integer
  182. settings: { }
  183. group_column: value
  184. group_columns: { }
  185. group_rows: true
  186. delta_limit: 0
  187. delta_offset: 0
  188. delta_reversed: false
  189. delta_first_last: false
  190. multi_type: separator
  191. field_api_classes: false
  192. entity_type: commerce_order_report
  193. entity_field: report_id
  194. plugin_id: field
  195. amount:
  196. id: amount
  197. table: commerce_order_report__amount
  198. field: amount
  199. relationship: none
  200. group_type: sum
  201. admin_label: ''
  202. label: 'Total Revenue'
  203. exclude: false
  204. alter:
  205. alter_text: false
  206. text: ''
  207. make_link: false
  208. path: ''
  209. absolute: false
  210. external: false
  211. replace_spaces: false
  212. path_case: none
  213. trim_whitespace: false
  214. alt: ''
  215. rel: ''
  216. link_class: ''
  217. prefix: ''
  218. suffix: ''
  219. target: ''
  220. nl2br: false
  221. max_length: 0
  222. word_boundary: true
  223. ellipsis: true
  224. more_link: false
  225. more_link_text: ''
  226. more_link_path: ''
  227. strip_tags: false
  228. trim: false
  229. preserve_tags: ''
  230. html: false
  231. element_type: ''
  232. element_class: ''
  233. element_label_type: ''
  234. element_label_class: ''
  235. element_label_colon: true
  236. element_wrapper_type: ''
  237. element_wrapper_class: ''
  238. element_default_classes: true
  239. empty: ''
  240. hide_empty: false
  241. empty_zero: false
  242. hide_alter_empty: true
  243. set_precision: false
  244. precision: 0
  245. decimal: .
  246. separator: ', '
  247. format_plural: 0
  248. format_plural_string: !!binary MQNAY291bnQ=
  249. prefix: ''
  250. suffix: ''
  251. click_sort_column: ''
  252. type: commerce_price_default
  253. settings: { }
  254. group_column: entity_id
  255. group_columns: { }
  256. group_rows: true
  257. delta_limit: 0
  258. delta_offset: 0
  259. delta_reversed: false
  260. delta_first_last: false
  261. multi_type: separator
  262. field_api_classes: false
  263. plugin_id: field
  264. amount_1:
  265. id: amount_1
  266. table: commerce_order_report__amount
  267. field: amount
  268. relationship: none
  269. group_type: avg
  270. admin_label: ''
  271. label: 'Average Order'
  272. exclude: false
  273. alter:
  274. alter_text: false
  275. text: ''
  276. make_link: false
  277. path: ''
  278. absolute: false
  279. external: false
  280. replace_spaces: false
  281. path_case: none
  282. trim_whitespace: false
  283. alt: ''
  284. rel: ''
  285. link_class: ''
  286. prefix: ''
  287. suffix: ''
  288. target: ''
  289. nl2br: false
  290. max_length: 0
  291. word_boundary: true
  292. ellipsis: true
  293. more_link: false
  294. more_link_text: ''
  295. more_link_path: ''
  296. strip_tags: false
  297. trim: false
  298. preserve_tags: ''
  299. html: false
  300. element_type: ''
  301. element_class: ''
  302. element_label_type: ''
  303. element_label_class: ''
  304. element_label_colon: true
  305. element_wrapper_type: ''
  306. element_wrapper_class: ''
  307. element_default_classes: true
  308. empty: ''
  309. hide_empty: false
  310. empty_zero: false
  311. hide_alter_empty: true
  312. set_precision: false
  313. precision: 0
  314. decimal: .
  315. separator: ', '
  316. format_plural: 0
  317. format_plural_string: !!binary MQNAY291bnQ=
  318. prefix: ''
  319. suffix: ''
  320. click_sort_column: ''
  321. type: commerce_price_default
  322. settings: { }
  323. group_column: entity_id
  324. group_columns: { }
  325. group_rows: true
  326. delta_limit: 0
  327. delta_offset: 0
  328. delta_reversed: false
  329. delta_first_last: false
  330. multi_type: separator
  331. field_api_classes: false
  332. plugin_id: field
  333. filters:
  334. type:
  335. id: type
  336. table: commerce_order_report
  337. field: type
  338. value:
  339. order_report: order_report
  340. entity_type: commerce_order_report
  341. entity_field: type
  342. plugin_id: commerce_entity_bundle
  343. created:
  344. id: created
  345. table: commerce_order_report
  346. field: created
  347. relationship: none
  348. group_type: group
  349. admin_label: ''
  350. operator: between
  351. value:
  352. min: '-11 months'
  353. max: 'last day of this month'
  354. value: ''
  355. type: offset
  356. group: 1
  357. exposed: true
  358. expose:
  359. operator_id: created_op
  360. label: 'Order date'
  361. description: ''
  362. use_operator: false
  363. operator: created_op
  364. identifier: date
  365. required: false
  366. remember: false
  367. multiple: false
  368. remember_roles:
  369. authenticated: authenticated
  370. anonymous: '0'
  371. administrator: '0'
  372. placeholder: ''
  373. min_placeholder: ''
  374. max_placeholder: ''
  375. is_grouped: false
  376. group_info:
  377. label: ''
  378. description: ''
  379. identifier: ''
  380. optional: true
  381. widget: select
  382. multiple: false
  383. remember: false
  384. default_group: All
  385. default_group_multiple: { }
  386. group_items: { }
  387. entity_type: commerce_order_report
  388. entity_field: created
  389. plugin_id: date
  390. sorts:
  391. created:
  392. id: created
  393. table: commerce_order_report
  394. field: created
  395. relationship: none
  396. group_type: group
  397. admin_label: ''
  398. order: DESC
  399. exposed: true
  400. expose:
  401. label: 'Order date'
  402. granularity: month
  403. entity_type: commerce_order_report
  404. entity_field: created
  405. plugin_id: date
  406. title: 'Monthly sales report'
  407. header: { }
  408. footer: { }
  409. empty: { }
  410. relationships: { }
  411. arguments: { }
  412. display_extenders: { }
  413. group_by: true
  414. cache_metadata:
  415. max-age: -1
  416. contexts:
  417. - 'languages:language_content'
  418. - 'languages:language_interface'
  419. - url
  420. - 'url.query_args:sort_by'
  421. - 'url.query_args:sort_order'
  422. - user.permissions
  423. tags: { }
  424. daily:
  425. display_plugin: page
  426. id: daily
  427. display_title: Daily
  428. position: 2
  429. display_options:
  430. display_extenders: { }
  431. display_description: ''
  432. title: 'Daily sales report'
  433. defaults:
  434. title: false
  435. fields: false
  436. sorts: false
  437. filters: false
  438. filter_groups: false
  439. path: admin/commerce/reports/sales/daily
  440. menu:
  441. type: tab
  442. title: Daily
  443. description: ''
  444. expanded: false
  445. parent: commerce_reports.overview
  446. weight: 10
  447. context: '0'
  448. menu_name: admin
  449. fields:
  450. created:
  451. id: created
  452. table: commerce_order_report
  453. field: created
  454. relationship: none
  455. group_type: group
  456. admin_label: ''
  457. label: Date
  458. exclude: false
  459. alter:
  460. alter_text: false
  461. text: ''
  462. make_link: false
  463. path: ''
  464. absolute: false
  465. external: false
  466. replace_spaces: false
  467. path_case: none
  468. trim_whitespace: false
  469. alt: ''
  470. rel: ''
  471. link_class: ''
  472. prefix: ''
  473. suffix: ''
  474. target: ''
  475. nl2br: false
  476. max_length: 0
  477. word_boundary: true
  478. ellipsis: true
  479. more_link: false
  480. more_link_text: ''
  481. more_link_path: ''
  482. strip_tags: false
  483. trim: false
  484. preserve_tags: ''
  485. html: false
  486. element_type: ''
  487. element_class: ''
  488. element_label_type: ''
  489. element_label_class: ''
  490. element_label_colon: true
  491. element_wrapper_type: ''
  492. element_wrapper_class: ''
  493. element_default_classes: true
  494. empty: ''
  495. hide_empty: false
  496. empty_zero: false
  497. hide_alter_empty: true
  498. click_sort_column: value
  499. type: timestamp
  500. settings:
  501. date_format: html_date
  502. custom_date_format: ''
  503. timezone: ''
  504. group_column: value
  505. group_columns: { }
  506. group_rows: true
  507. delta_limit: 0
  508. delta_offset: 0
  509. delta_reversed: false
  510. delta_first_last: false
  511. multi_type: separator
  512. separator: ', '
  513. field_api_classes: false
  514. entity_type: commerce_order_report
  515. entity_field: created
  516. plugin_id: commerce_reports_report_date_field
  517. report_id:
  518. id: report_id
  519. table: commerce_order_report
  520. field: report_id
  521. relationship: none
  522. group_type: count
  523. admin_label: ''
  524. label: '# of Orders'
  525. exclude: false
  526. alter:
  527. alter_text: false
  528. text: ''
  529. make_link: false
  530. path: ''
  531. absolute: false
  532. external: false
  533. replace_spaces: false
  534. path_case: none
  535. trim_whitespace: false
  536. alt: ''
  537. rel: ''
  538. link_class: ''
  539. prefix: ''
  540. suffix: ''
  541. target: ''
  542. nl2br: false
  543. max_length: 0
  544. word_boundary: true
  545. ellipsis: true
  546. more_link: false
  547. more_link_text: ''
  548. more_link_path: ''
  549. strip_tags: false
  550. trim: false
  551. preserve_tags: ''
  552. html: false
  553. element_type: ''
  554. element_class: ''
  555. element_label_type: ''
  556. element_label_class: ''
  557. element_label_colon: true
  558. element_wrapper_type: ''
  559. element_wrapper_class: ''
  560. element_default_classes: true
  561. empty: ''
  562. hide_empty: false
  563. empty_zero: false
  564. hide_alter_empty: true
  565. set_precision: false
  566. precision: 0
  567. decimal: .
  568. separator: ','
  569. format_plural: 0
  570. format_plural_string: !!binary MQNAY291bnQ=
  571. prefix: ''
  572. suffix: ''
  573. click_sort_column: value
  574. type: number_integer
  575. settings: { }
  576. group_column: value
  577. group_columns: { }
  578. group_rows: true
  579. delta_limit: 0
  580. delta_offset: 0
  581. delta_reversed: false
  582. delta_first_last: false
  583. multi_type: separator
  584. field_api_classes: false
  585. entity_type: commerce_order_report
  586. entity_field: report_id
  587. plugin_id: field
  588. amount:
  589. id: amount
  590. table: commerce_order_report__amount
  591. field: amount
  592. relationship: none
  593. group_type: sum
  594. admin_label: ''
  595. label: 'Total Revenue'
  596. exclude: false
  597. alter:
  598. alter_text: false
  599. text: ''
  600. make_link: false
  601. path: ''
  602. absolute: false
  603. external: false
  604. replace_spaces: false
  605. path_case: none
  606. trim_whitespace: false
  607. alt: ''
  608. rel: ''
  609. link_class: ''
  610. prefix: ''
  611. suffix: ''
  612. target: ''
  613. nl2br: false
  614. max_length: 0
  615. word_boundary: true
  616. ellipsis: true
  617. more_link: false
  618. more_link_text: ''
  619. more_link_path: ''
  620. strip_tags: false
  621. trim: false
  622. preserve_tags: ''
  623. html: false
  624. element_type: ''
  625. element_class: ''
  626. element_label_type: ''
  627. element_label_class: ''
  628. element_label_colon: true
  629. element_wrapper_type: ''
  630. element_wrapper_class: ''
  631. element_default_classes: true
  632. empty: ''
  633. hide_empty: false
  634. empty_zero: false
  635. hide_alter_empty: true
  636. set_precision: false
  637. precision: 0
  638. decimal: .
  639. separator: ', '
  640. format_plural: 0
  641. format_plural_string: !!binary MQNAY291bnQ=
  642. prefix: ''
  643. suffix: ''
  644. click_sort_column: ''
  645. type: commerce_price_default
  646. settings: { }
  647. group_column: entity_id
  648. group_columns: { }
  649. group_rows: true
  650. delta_limit: 0
  651. delta_offset: 0
  652. delta_reversed: false
  653. delta_first_last: false
  654. multi_type: separator
  655. field_api_classes: false
  656. plugin_id: field
  657. amount_1:
  658. id: amount_1
  659. table: commerce_order_report__amount
  660. field: amount
  661. relationship: none
  662. group_type: avg
  663. admin_label: ''
  664. label: 'Average Order'
  665. exclude: false
  666. alter:
  667. alter_text: false
  668. text: ''
  669. make_link: false
  670. path: ''
  671. absolute: false
  672. external: false
  673. replace_spaces: false
  674. path_case: none
  675. trim_whitespace: false
  676. alt: ''
  677. rel: ''
  678. link_class: ''
  679. prefix: ''
  680. suffix: ''
  681. target: ''
  682. nl2br: false
  683. max_length: 0
  684. word_boundary: true
  685. ellipsis: true
  686. more_link: false
  687. more_link_text: ''
  688. more_link_path: ''
  689. strip_tags: false
  690. trim: false
  691. preserve_tags: ''
  692. html: false
  693. element_type: ''
  694. element_class: ''
  695. element_label_type: ''
  696. element_label_class: ''
  697. element_label_colon: true
  698. element_wrapper_type: ''
  699. element_wrapper_class: ''
  700. element_default_classes: true
  701. empty: ''
  702. hide_empty: false
  703. empty_zero: false
  704. hide_alter_empty: true
  705. set_precision: false
  706. precision: 0
  707. decimal: .
  708. separator: ', '
  709. format_plural: 0
  710. format_plural_string: !!binary MQNAY291bnQ=
  711. prefix: ''
  712. suffix: ''
  713. click_sort_column: ''
  714. type: commerce_price_default
  715. settings: { }
  716. group_column: entity_id
  717. group_columns: { }
  718. group_rows: true
  719. delta_limit: 0
  720. delta_offset: 0
  721. delta_reversed: false
  722. delta_first_last: false
  723. multi_type: separator
  724. field_api_classes: false
  725. plugin_id: field
  726. sorts:
  727. created:
  728. id: created
  729. table: commerce_order_report
  730. field: created
  731. relationship: none
  732. group_type: group
  733. admin_label: ''
  734. order: DESC
  735. exposed: true
  736. expose:
  737. label: 'Order date'
  738. granularity: day
  739. entity_type: commerce_order_report
  740. entity_field: created
  741. plugin_id: date
  742. filters:
  743. type:
  744. id: type
  745. table: commerce_order_report
  746. field: type
  747. value:
  748. order_report: order_report
  749. entity_type: commerce_order_report
  750. entity_field: type
  751. plugin_id: commerce_entity_bundle
  752. created:
  753. id: created
  754. table: commerce_order_report
  755. field: created
  756. relationship: none
  757. group_type: group
  758. admin_label: ''
  759. operator: between
  760. value:
  761. min: '-180 days'
  762. max: 'last day of this year'
  763. value: ''
  764. type: offset
  765. group: 1
  766. exposed: true
  767. expose:
  768. operator_id: created_op
  769. label: 'Order date'
  770. description: ''
  771. use_operator: false
  772. operator: created_op
  773. identifier: date
  774. required: false
  775. remember: false
  776. multiple: false
  777. remember_roles:
  778. authenticated: authenticated
  779. anonymous: '0'
  780. administrator: '0'
  781. store_admin: '0'
  782. placeholder: ''
  783. min_placeholder: ''
  784. max_placeholder: ''
  785. is_grouped: false
  786. group_info:
  787. label: ''
  788. description: ''
  789. identifier: ''
  790. optional: true
  791. widget: select
  792. multiple: false
  793. remember: false
  794. default_group: All
  795. default_group_multiple: { }
  796. group_items: { }
  797. entity_type: commerce_order_report
  798. entity_field: created
  799. plugin_id: date
  800. filter_groups:
  801. operator: AND
  802. groups:
  803. 1: AND
  804. cache_metadata:
  805. max-age: -1
  806. contexts:
  807. - 'languages:language_content'
  808. - 'languages:language_interface'
  809. - url
  810. - 'url.query_args:sort_by'
  811. - 'url.query_args:sort_order'
  812. - user.permissions
  813. tags: { }
  814. monthly:
  815. display_plugin: page
  816. id: monthly
  817. display_title: Monthly
  818. position: 1
  819. display_options:
  820. display_extenders: { }
  821. path: admin/commerce/reports/sales
  822. menu:
  823. type: 'default tab'
  824. title: Monthly
  825. description: 'View monthly sales'
  826. expanded: false
  827. parent: commerce_reports.overview
  828. weight: 0
  829. context: '0'
  830. menu_name: admin
  831. display_description: ''
  832. tab_options:
  833. type: none
  834. title: Sales
  835. description: ''
  836. weight: 0
  837. cache_metadata:
  838. max-age: -1
  839. contexts:
  840. - 'languages:language_content'
  841. - 'languages:language_interface'
  842. - url
  843. - 'url.query_args:sort_by'
  844. - 'url.query_args:sort_order'
  845. - user.permissions
  846. tags: { }
  847. weekly:
  848. display_plugin: page
  849. id: weekly
  850. display_title: Weekly
  851. position: 2
  852. display_options:
  853. display_extenders: { }
  854. display_description: ''
  855. title: 'Weekly sales report'
  856. defaults:
  857. title: false
  858. fields: false
  859. sorts: false
  860. filters: false
  861. filter_groups: false
  862. path: admin/commerce/reports/sales/weekly
  863. menu:
  864. type: tab
  865. title: Weekly
  866. description: ''
  867. expanded: false
  868. parent: commerce_reports.overview
  869. weight: 5
  870. context: '0'
  871. menu_name: admin
  872. fields:
  873. created:
  874. id: created
  875. table: commerce_order_report
  876. field: created
  877. relationship: none
  878. group_type: group
  879. admin_label: ''
  880. label: Date
  881. exclude: false
  882. alter:
  883. alter_text: false
  884. text: ''
  885. make_link: false
  886. path: ''
  887. absolute: false
  888. external: false
  889. replace_spaces: false
  890. path_case: none
  891. trim_whitespace: false
  892. alt: ''
  893. rel: ''
  894. link_class: ''
  895. prefix: ''
  896. suffix: ''
  897. target: ''
  898. nl2br: false
  899. max_length: 0
  900. word_boundary: true
  901. ellipsis: true
  902. more_link: false
  903. more_link_text: ''
  904. more_link_path: ''
  905. strip_tags: false
  906. trim: false
  907. preserve_tags: ''
  908. html: false
  909. element_type: ''
  910. element_class: ''
  911. element_label_type: ''
  912. element_label_class: ''
  913. element_label_colon: true
  914. element_wrapper_type: ''
  915. element_wrapper_class: ''
  916. element_default_classes: true
  917. empty: ''
  918. hide_empty: false
  919. empty_zero: false
  920. hide_alter_empty: true
  921. click_sort_column: value
  922. type: timestamp
  923. settings:
  924. date_format: custom
  925. custom_date_format: Y-W
  926. timezone: ''
  927. group_column: value
  928. group_columns: { }
  929. group_rows: true
  930. delta_limit: 0
  931. delta_offset: 0
  932. delta_reversed: false
  933. delta_first_last: false
  934. multi_type: separator
  935. separator: ', '
  936. field_api_classes: false
  937. entity_type: commerce_order_report
  938. entity_field: created
  939. plugin_id: commerce_reports_report_date_field
  940. report_id:
  941. id: report_id
  942. table: commerce_order_report
  943. field: report_id
  944. relationship: none
  945. group_type: count
  946. admin_label: ''
  947. label: '# of Orders'
  948. exclude: false
  949. alter:
  950. alter_text: false
  951. text: ''
  952. make_link: false
  953. path: ''
  954. absolute: false
  955. external: false
  956. replace_spaces: false
  957. path_case: none
  958. trim_whitespace: false
  959. alt: ''
  960. rel: ''
  961. link_class: ''
  962. prefix: ''
  963. suffix: ''
  964. target: ''
  965. nl2br: false
  966. max_length: 0
  967. word_boundary: true
  968. ellipsis: true
  969. more_link: false
  970. more_link_text: ''
  971. more_link_path: ''
  972. strip_tags: false
  973. trim: false
  974. preserve_tags: ''
  975. html: false
  976. element_type: ''
  977. element_class: ''
  978. element_label_type: ''
  979. element_label_class: ''
  980. element_label_colon: true
  981. element_wrapper_type: ''
  982. element_wrapper_class: ''
  983. element_default_classes: true
  984. empty: ''
  985. hide_empty: false
  986. empty_zero: false
  987. hide_alter_empty: true
  988. set_precision: false
  989. precision: 0
  990. decimal: .
  991. separator: ','
  992. format_plural: 0
  993. format_plural_string: !!binary MQNAY291bnQ=
  994. prefix: ''
  995. suffix: ''
  996. click_sort_column: value
  997. type: number_integer
  998. settings: { }
  999. group_column: value
  1000. group_columns: { }
  1001. group_rows: true
  1002. delta_limit: 0
  1003. delta_offset: 0
  1004. delta_reversed: false
  1005. delta_first_last: false
  1006. multi_type: separator
  1007. field_api_classes: false
  1008. entity_type: commerce_order_report
  1009. entity_field: report_id
  1010. plugin_id: field
  1011. amount:
  1012. id: amount
  1013. table: commerce_order_report__amount
  1014. field: amount
  1015. relationship: none
  1016. group_type: sum
  1017. admin_label: ''
  1018. label: 'Total Revenue'
  1019. exclude: false
  1020. alter:
  1021. alter_text: false
  1022. text: ''
  1023. make_link: false
  1024. path: ''
  1025. absolute: false
  1026. external: false
  1027. replace_spaces: false
  1028. path_case: none
  1029. trim_whitespace: false
  1030. alt: ''
  1031. rel: ''
  1032. link_class: ''
  1033. prefix: ''
  1034. suffix: ''
  1035. target: ''
  1036. nl2br: false
  1037. max_length: 0
  1038. word_boundary: true
  1039. ellipsis: true
  1040. more_link: false
  1041. more_link_text: ''
  1042. more_link_path: ''
  1043. strip_tags: false
  1044. trim: false
  1045. preserve_tags: ''
  1046. html: false
  1047. element_type: ''
  1048. element_class: ''
  1049. element_label_type: ''
  1050. element_label_class: ''
  1051. element_label_colon: true
  1052. element_wrapper_type: ''
  1053. element_wrapper_class: ''
  1054. element_default_classes: true
  1055. empty: ''
  1056. hide_empty: false
  1057. empty_zero: false
  1058. hide_alter_empty: true
  1059. set_precision: false
  1060. precision: 0
  1061. decimal: .
  1062. separator: ', '
  1063. format_plural: 0
  1064. format_plural_string: !!binary MQNAY291bnQ=
  1065. prefix: ''
  1066. suffix: ''
  1067. click_sort_column: ''
  1068. type: commerce_price_default
  1069. settings: { }
  1070. group_column: entity_id
  1071. group_columns: { }
  1072. group_rows: true
  1073. delta_limit: 0
  1074. delta_offset: 0
  1075. delta_reversed: false
  1076. delta_first_last: false
  1077. multi_type: separator
  1078. field_api_classes: false
  1079. plugin_id: field
  1080. amount_1:
  1081. id: amount_1
  1082. table: commerce_order_report__amount
  1083. field: amount
  1084. relationship: none
  1085. group_type: avg
  1086. admin_label: ''
  1087. label: 'Average Order'
  1088. exclude: false
  1089. alter:
  1090. alter_text: false
  1091. text: ''
  1092. make_link: false
  1093. path: ''
  1094. absolute: false
  1095. external: false
  1096. replace_spaces: false
  1097. path_case: none
  1098. trim_whitespace: false
  1099. alt: ''
  1100. rel: ''
  1101. link_class: ''
  1102. prefix: ''
  1103. suffix: ''
  1104. target: ''
  1105. nl2br: false
  1106. max_length: 0
  1107. word_boundary: true
  1108. ellipsis: true
  1109. more_link: false
  1110. more_link_text: ''
  1111. more_link_path: ''
  1112. strip_tags: false
  1113. trim: false
  1114. preserve_tags: ''
  1115. html: false
  1116. element_type: ''
  1117. element_class: ''
  1118. element_label_type: ''
  1119. element_label_class: ''
  1120. element_label_colon: true
  1121. element_wrapper_type: ''
  1122. element_wrapper_class: ''
  1123. element_default_classes: true
  1124. empty: ''
  1125. hide_empty: false
  1126. empty_zero: false
  1127. hide_alter_empty: true
  1128. set_precision: false
  1129. precision: 0
  1130. decimal: .
  1131. separator: ', '
  1132. format_plural: 0
  1133. format_plural_string: !!binary MQNAY291bnQ=
  1134. prefix: ''
  1135. suffix: ''
  1136. click_sort_column: ''
  1137. type: commerce_price_default
  1138. settings: { }
  1139. group_column: entity_id
  1140. group_columns: { }
  1141. group_rows: true
  1142. delta_limit: 0
  1143. delta_offset: 0
  1144. delta_reversed: false
  1145. delta_first_last: false
  1146. multi_type: separator
  1147. field_api_classes: false
  1148. plugin_id: field
  1149. sorts:
  1150. created:
  1151. id: created
  1152. table: commerce_order_report
  1153. field: created
  1154. relationship: none
  1155. group_type: group
  1156. admin_label: ''
  1157. order: DESC
  1158. exposed: true
  1159. expose:
  1160. label: 'Order date'
  1161. granularity: week
  1162. entity_type: commerce_order_report
  1163. entity_field: created
  1164. plugin_id: date
  1165. filters:
  1166. type:
  1167. id: type
  1168. table: commerce_order_report
  1169. field: type
  1170. value:
  1171. order_report: order_report
  1172. entity_type: commerce_order_report
  1173. entity_field: type
  1174. plugin_id: commerce_entity_bundle
  1175. created:
  1176. id: created
  1177. table: commerce_order_report
  1178. field: created
  1179. relationship: none
  1180. group_type: group
  1181. admin_label: ''
  1182. operator: between
  1183. value:
  1184. min: '-10 years'
  1185. max: 'last day of this year'
  1186. value: ''
  1187. type: offset
  1188. group: 1
  1189. exposed: true
  1190. expose:
  1191. operator_id: created_op
  1192. label: 'Order date'
  1193. description: ''
  1194. use_operator: false
  1195. operator: created_op
  1196. identifier: date
  1197. required: false
  1198. remember: false
  1199. multiple: false
  1200. remember_roles:
  1201. authenticated: authenticated
  1202. anonymous: '0'
  1203. administrator: '0'
  1204. placeholder: ''
  1205. min_placeholder: ''
  1206. max_placeholder: ''
  1207. is_grouped: false
  1208. group_info:
  1209. label: ''
  1210. description: ''
  1211. identifier: ''
  1212. optional: true
  1213. widget: select
  1214. multiple: false
  1215. remember: false
  1216. default_group: All
  1217. default_group_multiple: { }
  1218. group_items: { }
  1219. entity_type: commerce_order_report
  1220. entity_field: created
  1221. plugin_id: date
  1222. filter_groups:
  1223. operator: AND
  1224. groups:
  1225. 1: AND
  1226. cache_metadata:
  1227. max-age: -1
  1228. contexts:
  1229. - 'languages:language_content'
  1230. - 'languages:language_interface'
  1231. - url
  1232. - 'url.query_args:sort_by'
  1233. - 'url.query_args:sort_order'
  1234. - user.permissions
  1235. tags: { }
  1236. yearly:
  1237. display_plugin: page
  1238. id: yearly
  1239. display_title: Yearly
  1240. position: 2
  1241. display_options:
  1242. display_extenders: { }
  1243. display_description: ''
  1244. title: 'Yearly sales report'
  1245. defaults:
  1246. title: false
  1247. fields: false
  1248. sorts: false
  1249. filters: false
  1250. filter_groups: false
  1251. path: admin/commerce/reports/sales/yearly
  1252. menu:
  1253. type: tab
  1254. title: Yearly
  1255. description: ''
  1256. expanded: false
  1257. parent: commerce_reports.overview
  1258. weight: -10
  1259. context: '0'
  1260. menu_name: admin
  1261. fields:
  1262. created:
  1263. id: created
  1264. table: commerce_order_report
  1265. field: created
  1266. relationship: none
  1267. group_type: group
  1268. admin_label: ''
  1269. label: Date
  1270. exclude: false
  1271. alter:
  1272. alter_text: false
  1273. text: ''
  1274. make_link: false
  1275. path: ''
  1276. absolute: false
  1277. external: false
  1278. replace_spaces: false
  1279. path_case: none
  1280. trim_whitespace: false
  1281. alt: ''
  1282. rel: ''
  1283. link_class: ''
  1284. prefix: ''
  1285. suffix: ''
  1286. target: ''
  1287. nl2br: false
  1288. max_length: 0
  1289. word_boundary: true
  1290. ellipsis: true
  1291. more_link: false
  1292. more_link_text: ''
  1293. more_link_path: ''
  1294. strip_tags: false
  1295. trim: false
  1296. preserve_tags: ''
  1297. html: false
  1298. element_type: ''
  1299. element_class: ''
  1300. element_label_type: ''
  1301. element_label_class: ''
  1302. element_label_colon: true
  1303. element_wrapper_type: ''
  1304. element_wrapper_class: ''
  1305. element_default_classes: true
  1306. empty: ''
  1307. hide_empty: false
  1308. empty_zero: false
  1309. hide_alter_empty: true
  1310. click_sort_column: value
  1311. type: timestamp
  1312. settings:
  1313. date_format: html_year
  1314. custom_date_format: ''
  1315. timezone: ''
  1316. group_column: value
  1317. group_columns: { }
  1318. group_rows: true
  1319. delta_limit: 0
  1320. delta_offset: 0
  1321. delta_reversed: false
  1322. delta_first_last: false
  1323. multi_type: separator
  1324. separator: ', '
  1325. field_api_classes: false
  1326. entity_type: commerce_order_report
  1327. entity_field: created
  1328. plugin_id: commerce_reports_report_date_field
  1329. report_id:
  1330. id: report_id
  1331. table: commerce_order_report
  1332. field: report_id
  1333. relationship: none
  1334. group_type: count
  1335. admin_label: ''
  1336. label: '# of Orders'
  1337. exclude: false
  1338. alter:
  1339. alter_text: false
  1340. text: ''
  1341. make_link: false
  1342. path: ''
  1343. absolute: false
  1344. external: false
  1345. replace_spaces: false
  1346. path_case: none
  1347. trim_whitespace: false
  1348. alt: ''
  1349. rel: ''
  1350. link_class: ''
  1351. prefix: ''
  1352. suffix: ''
  1353. target: ''
  1354. nl2br: false
  1355. max_length: 0
  1356. word_boundary: true
  1357. ellipsis: true
  1358. more_link: false
  1359. more_link_text: ''
  1360. more_link_path: ''
  1361. strip_tags: false
  1362. trim: false
  1363. preserve_tags: ''
  1364. html: false
  1365. element_type: ''
  1366. element_class: ''
  1367. element_label_type: ''
  1368. element_label_class: ''
  1369. element_label_colon: true
  1370. element_wrapper_type: ''
  1371. element_wrapper_class: ''
  1372. element_default_classes: true
  1373. empty: ''
  1374. hide_empty: false
  1375. empty_zero: false
  1376. hide_alter_empty: true
  1377. set_precision: false
  1378. precision: 0
  1379. decimal: .
  1380. separator: ','
  1381. format_plural: 0
  1382. format_plural_string: !!binary MQNAY291bnQ=
  1383. prefix: ''
  1384. suffix: ''
  1385. click_sort_column: value
  1386. type: number_integer
  1387. settings: { }
  1388. group_column: value
  1389. group_columns: { }
  1390. group_rows: true
  1391. delta_limit: 0
  1392. delta_offset: 0
  1393. delta_reversed: false
  1394. delta_first_last: false
  1395. multi_type: separator
  1396. field_api_classes: false
  1397. entity_type: commerce_order_report
  1398. entity_field: report_id
  1399. plugin_id: field
  1400. amount:
  1401. id: amount
  1402. table: commerce_order_report__amount
  1403. field: amount
  1404. relationship: none
  1405. group_type: sum
  1406. admin_label: ''
  1407. label: 'Total Revenue'
  1408. exclude: false
  1409. alter:
  1410. alter_text: false
  1411. text: ''
  1412. make_link: false
  1413. path: ''
  1414. absolute: false
  1415. external: false
  1416. replace_spaces: false
  1417. path_case: none
  1418. trim_whitespace: false
  1419. alt: ''
  1420. rel: ''
  1421. link_class: ''
  1422. prefix: ''
  1423. suffix: ''
  1424. target: ''
  1425. nl2br: false
  1426. max_length: 0
  1427. word_boundary: true
  1428. ellipsis: true
  1429. more_link: false
  1430. more_link_text: ''
  1431. more_link_path: ''
  1432. strip_tags: false
  1433. trim: false
  1434. preserve_tags: ''
  1435. html: false
  1436. element_type: ''
  1437. element_class: ''
  1438. element_label_type: ''
  1439. element_label_class: ''
  1440. element_label_colon: true
  1441. element_wrapper_type: ''
  1442. element_wrapper_class: ''
  1443. element_default_classes: true
  1444. empty: ''
  1445. hide_empty: false
  1446. empty_zero: false
  1447. hide_alter_empty: true
  1448. set_precision: false
  1449. precision: 0
  1450. decimal: .
  1451. separator: ', '
  1452. format_plural: 0
  1453. format_plural_string: !!binary MQNAY291bnQ=
  1454. prefix: ''
  1455. suffix: ''
  1456. click_sort_column: ''
  1457. type: commerce_price_default
  1458. settings: { }
  1459. group_column: entity_id
  1460. group_columns: { }
  1461. group_rows: true
  1462. delta_limit: 0
  1463. delta_offset: 0
  1464. delta_reversed: false
  1465. delta_first_last: false
  1466. multi_type: separator
  1467. field_api_classes: false
  1468. plugin_id: field
  1469. amount_1:
  1470. id: amount_1
  1471. table: commerce_order_report__amount
  1472. field: amount
  1473. relationship: none
  1474. group_type: avg
  1475. admin_label: ''
  1476. label: 'Average Order'
  1477. exclude: false
  1478. alter:
  1479. alter_text: false
  1480. text: ''
  1481. make_link: false
  1482. path: ''
  1483. absolute: false
  1484. external: false
  1485. replace_spaces: false
  1486. path_case: none
  1487. trim_whitespace: false
  1488. alt: ''
  1489. rel: ''
  1490. link_class: ''
  1491. prefix: ''
  1492. suffix: ''
  1493. target: ''
  1494. nl2br: false
  1495. max_length: 0
  1496. word_boundary: true
  1497. ellipsis: true
  1498. more_link: false
  1499. more_link_text: ''
  1500. more_link_path: ''
  1501. strip_tags: false
  1502. trim: false
  1503. preserve_tags: ''
  1504. html: false
  1505. element_type: ''
  1506. element_class: ''
  1507. element_label_type: ''
  1508. element_label_class: ''
  1509. element_label_colon: true
  1510. element_wrapper_type: ''
  1511. element_wrapper_class: ''
  1512. element_default_classes: true
  1513. empty: ''
  1514. hide_empty: false
  1515. empty_zero: false
  1516. hide_alter_empty: true
  1517. set_precision: false
  1518. precision: 0
  1519. decimal: .
  1520. separator: ', '
  1521. format_plural: 0
  1522. format_plural_string: !!binary MQNAY291bnQ=
  1523. prefix: ''
  1524. suffix: ''
  1525. click_sort_column: ''
  1526. type: commerce_price_default
  1527. settings: { }
  1528. group_column: entity_id
  1529. group_columns: { }
  1530. group_rows: true
  1531. delta_limit: 0
  1532. delta_offset: 0
  1533. delta_reversed: false
  1534. delta_first_last: false
  1535. multi_type: separator
  1536. field_api_classes: false
  1537. plugin_id: field
  1538. sorts:
  1539. created:
  1540. id: created
  1541. table: commerce_order_report
  1542. field: created
  1543. relationship: none
  1544. group_type: group
  1545. admin_label: ''
  1546. order: DESC
  1547. exposed: true
  1548. expose:
  1549. label: 'Order date'
  1550. granularity: year
  1551. entity_type: commerce_order_report
  1552. entity_field: created
  1553. plugin_id: date
  1554. filters:
  1555. type:
  1556. id: type
  1557. table: commerce_order_report
  1558. field: type
  1559. value:
  1560. order_report: order_report
  1561. entity_type: commerce_order_report
  1562. entity_field: type
  1563. plugin_id: commerce_entity_bundle
  1564. created:
  1565. id: created
  1566. table: commerce_order_report
  1567. field: created
  1568. relationship: none
  1569. group_type: group
  1570. admin_label: ''
  1571. operator: between
  1572. value:
  1573. min: '-10 years'
  1574. max: 'last day of this year'
  1575. value: ''
  1576. type: offset
  1577. group: 1
  1578. exposed: true
  1579. expose:
  1580. operator_id: created_op
  1581. label: 'Order date'
  1582. description: ''
  1583. use_operator: false
  1584. operator: created_op
  1585. identifier: date
  1586. required: false
  1587. remember: false
  1588. multiple: false
  1589. remember_roles:
  1590. authenticated: authenticated
  1591. anonymous: '0'
  1592. administrator: '0'
  1593. placeholder: ''
  1594. min_placeholder: ''
  1595. max_placeholder: ''
  1596. is_grouped: false
  1597. group_info:
  1598. label: ''
  1599. description: ''
  1600. identifier: ''
  1601. optional: true
  1602. widget: select
  1603. multiple: false
  1604. remember: false
  1605. default_group: All
  1606. default_group_multiple: { }
  1607. group_items: { }
  1608. entity_type: commerce_order_report
  1609. entity_field: created
  1610. plugin_id: date
  1611. filter_groups:
  1612. operator: AND
  1613. groups:
  1614. 1: AND
  1615. cache_metadata:
  1616. max-age: -1
  1617. contexts:
  1618. - 'languages:language_content'
  1619. - 'languages:language_interface'
  1620. - url
  1621. - 'url.query_args:sort_by'
  1622. - 'url.query_args:sort_order'
  1623. - user.permissions
  1624. tags: { }