Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

How to get Single Value to skip null values

  • 20 January 2017
  • 5 replies
  • 300 views
S

I’m trying to get Single Value to display a percentage increase of our lead numbers month over month. I’m filtering both months on month to date measures (1st to the 10th of both months) and created a table calculation to show the increase month over month so far. That table calc shows a null value for last month and the percentage for the current month. Is there anyway for Single Value to bypass the null value and display the percentage?


5 replies

sam
Rank
Userlevel 5
Badge

Hey @smcmullen, just an initial thought, why not sort by the percentage instead? Single Value will default to the first row, so we should set up the calc such that the value shows up in the first row.

S

Hi @sam, it’s an offset calculation that doesn’t let me sort. If there is an easier way to calculate percent of previous, that might be a solution.

sam
Rank
Userlevel 5
Badge

@smcmullen - you’re right; I see now why we couldn’t just sort the other way. However, what if we used offset the other way? It looks like you’re using a negative offset right now, why not change it to a positive one?

S

That worked! Thanks for your help @sam

sam
Rank
Userlevel 5
Badge

Wonderful @smcmullen! Glad to help!

Reply


Terms of Service