Table (matrix) with TopN and others
This one is a bit tricky but solves a common wish of showing af table with the Top number of x plus others. There are several tricks involved in this one - first we use a matrix and add the numeric fieldparameter value to the rows and then the attribute we want to group the items by - hide the +/- icon and then we use different visual calculations to show the attributes value if is matches the rank number of the product. Visual calculation functions used: EXPAND RANK ISINSCOPE RUNNINGSUM A large dataset will affect the performance and you might want to consider alternatives Enjoy visual calcs ErikMatrix box plot
In this item I am using a different visual calculations to at the end construct a text string based on unichar's so it looks like a box plot. In this way we can simulate a vertical box plot in a table where the sorting features of a table could be relevant. This might also inspire you to use a unichar text string to illustrate other elements - for instance a gantt chart Enjoy visual calc's ErikBoxplot
This one uses visual calculations to create a box plot within a line and stacked column chart. The box plot grouping is determined by a field parameter so it is very dynamic. The main trick is to add the value to plot to the x-axis fields under the grouping and then the visual will contain all the necessary data to calculate the values for the box plot values. If you dataset is large there might be a performance issue. Have fun with the vc's ErikSwitch between line and column chart
This one uses two visual calculations to plot the fact either as the column value or as the line value to enable a switch between a column or a line chart. Its controlled by a numeric field parameter - with the values 0 and 1 - and then the slicer uses a custom number format to show the values as "Line" or "Chart". The value of the field parameter is added to the tooltip section of the chart and can then be uses in the VC's to return the value or blank depending on they choose line or chart. Have VC fun ErikHighlight min and max
This one uses the RANK function to find the highest value and lowest value and then calculates a color code if the rank = 1 and when its equal to the number of rows in the visuals data. An alternative to use the RANK function is to use the MINX and MAXX to find out whether the the Sales Value is equal to those values. Remember to set the data format to text for the color calculations Have VC fun ErikTopN and Others plus dynamic title
This report shows you how you can use visual calculations together with field paramters to highlight x no of items in your bar chart. It will also use visual calculations to generate a dynamic text that can be used as a subtitle in the visual to add context of what is highlighted and the share of totals. Uses: RANK EXPAND @
