Versions Compared

Old Version 12

changes.mady.by.user Karen Hogan

Saved on

compared with

New Version Current

changes.mady.by.user Karen Hogan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

With effect from the pi.2022-03-31 dashboard release:

...

The ‘Type to filter’ screen has now been split into two sections - Data and Charts. The Data screen is used in the same way as it was previously (please see this page for more information) and there is now an additional ‘Charts’ screen.

The screenshot below shows the chart types that can be selected from the ‘Charts’ screen. If a chart type can not be used in a sub-query it will not be available displayed on the' Charts' screen under ‘Type to filter’.

...

Why use sub-query

By using Sub-query, you will be able to:

...

In this example, the total time to build all charts is 748ms586ms. This includes the 309ms 352ms taken to build the sub-query chart - you can see this information at the bottom of the debug page on the main chart.

...

Info

To reduce the length of time taken to draw your chart, try to avoid using lots of sub-query references in your charts.

...

  • Cycle referencing: If Chart 1 uses Chart 2, Chart 2 uses Chart 3, Chart 3 uses either Chart 1 or Chart 2 as sub-query, the system shows an error

  • Sub-charts are changed: If a sub-chart is edited afterwards, you may get unexpected results on the main chart while the main chart is not likely to be broken, because the main chart simply just picks the first column or first data point of the sub-charts, it doesn’t care how the sub-charts are configured

  • Sub-charts not having data: again, the main chart is not likely to display data since there isn’t anything relevant

Elementor macro
rowWidth100
title0h8n66
content[{"id":"bw6mx","order":1662462304798,"background":{"source":"color","value":"#ffffff","id":""},"backgroundOverlay":{"isActive":false,"color":"#000000","opacity":0.5},"rows":[{"id":"mach3k","order":1662462304798,"type":"one","columns":[{"id":"5v2xhk","order":1,"alignment":{"vertical":"center","horizontal":"center"},"macro":{"id":"pagedivider","dividerColor":"#8d135bff","text":"Related Topics","fontSize":24,"textAlignment":"center","dividerWidth":100,"dividerWeight":3,"dividerType":"text-only","dividerIcon":"atlaskit/StarFilledIcon","textColor":"#8d135bff","iconColor":"#000","labelPosition":"middle","emojiEnabled":"false","emoji":{"id":"smile","name":"Smiling Face with Open Mouth and Smiling Eyes","short_names":["smile"],"colons":":smile:","emoticons":["C:","c:",":D",":-D"],"unified":"1f604","skin":null,"native":"😄"}}},{"id":"2p7yz","order":2,"alignment":{"vertical":"center","horizontal":"center"},"macro":{}},{"id":"gd4dr","order":3,"alignment":{"vertical":"center","horizontal":"center"},"macro":{}},{"id":"4cq6v","order":4,"alignment":{"vertical":"center","horizontal":"center"},"macro":{}}]},{"id":"xcgo7b","order":1662462374011,"type":"one","columns":[{"id":"ayxccs","order":1,"alignment":{"vertical":"center","horizontal":"center"},"macro":{"id":"pages","type":"list","layout":"four","loadType":"manual","parentPage":"","manualPages":[{"id":"b2a3wl","position":0,"contentId":"1100939294"}],"labels":[],"spaces":[],"contributors":[],"numberOfItems":8,"pagination":"infinite"}},{"id":"uz10ba","order":2,"alignment":{"vertical":"center","horizontal":"center"},"macro":{}},{"id":"nrke9n","order":3,"alignment":{"vertical":"center","horizontal":"center"},"macro":{}},{"id":"foo6pq","order":4,"alignment":{"vertical":"center","horizontal":"center"},"macro":{}}]}]}]