Forum Discussion
hasarinfareeth
1 year agoFrequent Visitor
Dynamic calculated column in Matrix Table
Hi I am tryng to add a dynamic column in a Matrix table visual I need to show 'Up' arrow symbol if the number of tickets closed for current month is more than last month and 'Down' arrow symbol ...
parry2k
Super User
1 year agohasarinfareeth you can easily use time intelligence function to compare current month value with the previous month. There are many time intelligence videos/posts on how to get previous month data. Once you have that calculation in place than you can use conditional formatting to show arrows.
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist