CODEWITHSUNDEEP
javascriptchartsgoogle-visualization
tlewis3348
tlewis3348

Reputation: 486

How can I show data equal to zero on a log scale?

What I'm working with

I have data that I want to chart showing the intensity of rainfall over a period of time. The API documentation that I'm getting this data from says the following:

A very rough guide is that a value of 0 in./hr. corresponds to no precipitation, 0.002 in./hr. corresponds to very light precipitation, 0.017 in./hr. corresponds to light precipitation, 0.1 in./hr. corresponds to moderate precipitation, and 0.4 in./hr. corresponds to heavy precipitation.

Therefore, it seems logical to use a log scale for most of the data (otherwise everything less than moderate rain would be imperceptible), but this obviously causes a problem for when there is no rain predicted.

Possible Solution

The answer to this question suggested adding a small amount to the data and modifying the tooltip to match the original data.

Problem

This would work very nicely, but I don't know how to modify just the data that the tooltip of a Google Chart (the charting tool I'm using) references.

The Google Chart help documents here and here describe several possible roles columns from the chart's data table can play, and one of them is to be the HTML that is rendered in the tooltip. However, I was really hoping to not have to rewrite the HTML for that. Is there anyone here that knows an easy way to just modify the data shown in the tooltip?

Upvotes: 0

Views: 92

Answers (1)

Henrik Aronsson
Henrik Aronsson

Reputation: 1413

The second link you provide gives you the easiest way to modify your tooltip content, Link. Just add another column like dataTable.addColumn({type: 'string', role: 'tooltip'});and then provide your own tooltip, like looping through all your rows and checking for zero values and replacing the tooltips where needed.

Upvotes: 1

Related Questions