Knowledge Drop

Can I choose what row value to show in a Single Value Visualization?

  • 5 April 2021
  • 0 replies
  • 1362 views

Userlevel 5

Last Tested: Jul 3, 2018

 

By default no, but there is a workaround. For further reference on the default behavior, see the logic in Docs.

There are a couple ways to visualize a specific row from the results table:
 

Specific Row Value with YesNo

For example, to always show the last value in a column, use:

row()-count(${dimension_name})=0

 

This will only be Yes for the last value. Then choose the Hide "No"s from Visualization option.

You could then adjust this to show the 2nd to last row, and so on:

#for 2nd to last row

row()-count(${dimension_name})=-1

 

Reverse Running Total

If you created a running total table calculation and want to show the "bottom" value, you can reverse the running total using

Running Total Up:
sum(offset_list(${measure},0,count(${dimension})-row()+1))

 

In that scenario, the first workaround could be applied as well.

 

This content is subject to limited support.                

 


0 replies

Be the first to reply!

Reply