{"id":7242,"date":"2024-08-15T12:21:57","date_gmt":"2024-08-15T09:21:57","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&p=7242"},"modified":"2024-08-15T12:23:55","modified_gmt":"2024-08-15T09:23:55","slug":"shovani-elementy-danyh","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-interaktyvnogo-deshborda\/shovani-elementy-danyh\/","title":{"rendered":"Hidden data items"},"content":{"rendered":"

Each dashboard element in the \u201cData Items\u201d field contains an additional field \u2013 \u201cHidden Data Items\u201d:<\/p>\n

\"\"<\/a><\/p>\n

Elements of this field can be used as a context.<\/p>\n

Let us consider it on an example of one of the previous tables:<\/p>\n

\"\"<\/a><\/p>\n

We display the 7 best values of the \u201cOrder Count\u201d measure for each product category only for year 2018. For this, drop the \u201cCalendar Year\u201d hierarchy into the \u201cHidden Data Items\u201d field:<\/p>\n

\"\"<\/a><\/p>\n

Now, from the context menu (by a right-click), select \u201cEdit Filter\u201d icon:<\/p>\n

\"\"<\/a><\/p>\n

In the drop-down list, select the \u201cCalendar Year\u201d hierarchy:<\/p>\n

\"\"<\/a><\/p>\n

And then specify the year:<\/p>\n

\"\"<\/a><\/p>\n

Now the table displays the 7 best values of the \u201cOrder Count\u201d measure for each product category for year 2018 only:<\/p>\n

\"\"<\/a><\/p>","protected":false},"featured_media":0,"parent":5521,"menu_order":536,"template":"","manuals":[18],"class_list":["post-7242","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/7242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/5521"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=7242"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=7242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}