Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dataset with current and historical daily data on an hourly basis. The current days data only exists up to current time. Because of this, when comparing the hour by hour information, my chart shows current value = 0 for any time stamp > now. I tried creating a dimension to replace the imported timestamp, but the condition is not taking. Can someone tell me where I am going wrong? The idea is that each value above hour 15 should be NULL and I can use ignore null to remove them from my line chart.
My calculated dimension (far right) is: =if(hour <= Date(Now(),'hh'), hour, NULL())
you may be comparing different data types. i suggest using hour(now()) and compare it with hour(TIMESTAMPFIELD) or maybe you already extracted the hour into a number field, the hour function return an integer and will be same type
I am moving this to the App development board for better visibility