We used 366 * SUM(.)/1000, but you would normally use whatever your expected highest value instead of the 366, or your Max value in your data set. The dual axis of Rows is *1.0 for the first axis and an Interpolated value for the Number of Calls to scale it on a 0-100 scale.
This was joined to a similarly named field in the Call Center data source: To join the data he created a time field off of NOW(): I called Jonathan Drummey to pick his brain on the best way to do this. To blend in the call center data, the datetime and number of calls needed to be converted to match the axis of the mood grid. Bringing this into Tableau as the primary sheet, I could create a gradient easily by putting and where they usually go, and on color. To do this, I created a very simple sheet with a pixel for every combination of X (0-100) and Y (0-100) to use to create my "moods". Initially, I thought of using a view swapper or changing the background image based on a value, but I have other devious ambient lighting plans, so I wanted to start to play with it as pixels.
Of course, this is a DataBlick widget, so it needs more glitter!!!! My widget was for the number of calls from LA 311 (thank you Allan for finding the data), I wanted to have the background of my widget update its background color with an ambient mood gradient depending on if the volume of calls was in one of 3 ranges (alert!, a bit on the high side, or mellow). Viz1 = new tableauSoftware.Viz(onePh, oneUrl, oneOptions) Var onePh = document.getElementById("tableauViz1") Var viz, one, workbook, activeSheet, Worksheet, worksheet Just swap out your published viz for the Calls one below: Once you have pubished your workbook, you can add it to a webpage and animate it with Allan's code. Mine for example just shows the last 60 seconds. Taking advantage of the same technique for animation as used in the Polar Clock, you can use comparisons from a time field in your data to the current time minus how far in the past you want to show in your dashboard. You can then move the widget from your Mac dashboard to your desktop with this easy to follow step by step guide.
0 kommentar(er)
