TARGIT Tips and Tricks

Visualization

• Create a summary of data in text
• Labels on selected columns in column chart
• Drill Down Indicator
• Color intersection between calculated column and calculated row
• Hierarchical collation (sorting) or not?
• Custom color scales - ideal for heat map types

See all 9 articles

Administration

• 8 things you can do yourself to improve performance in TARGIT

Data Discovery

• 6 best practice recommendations for using and maintaining your Data Discovery Environment

Layouts

• Different content in portrait and landscape versions of layout
• Mobile layouts that allow scrolling
• Trigger to layout with detail data

Web Boxes

• Youtube videos autoplay and loop
• Web boxes with dynamic Weather Forecast data from DMI

Tips and Tricks - 2021 Christmas edition

• December 1st: Bookmarks from a consumer and a designer perspective
• December 2nd: Text rows and row formatting in x-tables
• December 3rd: Source data – hidden gems
• December 4th: Preferred shortcuts in TARGIT
• December 5th: Subtotals – hidden gems
• December 6th: Smartpad - hidden gems

See all 24 articles

Calculations

• Addressing levels in hierarchies #2
• Addressing levels in hierarchies #1
• Top list with sum of the rest - video guide
• Using MOD result modifier to identify and highlight every third column
• Result Modifiers
• Multidimensional Subtotals

Scheduled Jobs

• Email member property in Excel sheet for batch scheduled job

Maps Visualization Contest Tips & Tricks

• Videos
• SVG map as matrix (heat map)
• Using layers to create a custom visual (popcorn cup)
• Intelligent use of colors on maps (and other objects)
• Using bar-charts as slicers
• Creative use of crosstab theme to show bonus info

See all 9 articles

Miscellaneous

• Simple optimization for analysis based on Tabular database (disable totals and subtotals)
• How-to setup a webhook that updates your trello board
• Search operators OR/NOT/AND in the Anywhere client