Script to change column width of an item or all items

XLOOKUP is promised to be the only Excel lookup function you need, mostly replacing VLOOKUP and INDEX & MATCH. But it has problems which I outline in this video.I cover 4 problems of Excel XLOOKUP and compare it to SELECT function of Quantrix Modeler.

Watch step-by-step instruction for building a Bullet graph in Quantrix. A bullet graph is a variation of a bar graph that shows progress towards a goal or performance against a reference line. A bullet graph consists of a featured measure (such as current revenue), a reference line (such as a target), and qualitative ranges (such…

Check out our new YouTube video about Dashboards: Sales, Customer Analytics, Budget vs. Actual. Subscribe to our YouTube channel

I think the most interesting way of using role names is in creating different views of the same Matrix based on the role. This means users with different roles will see different parts of the matrix assigned to them. We can do it by using the role name variable in filter expression. You save your…