Looker Version:
## Context
value_format definition:
201 seconds
to mm:ss
should be 03:21.
3 * 60 + 21 = 201;
But the looker displayed result is wrong:
The result is `03:20` , which is not right.
I create a Calculations:
The Calculations are right:
Also Visualization is correct:
Code:
```
view: demo {
derived_table: {
sql: select 201 as seconds ;;
}
dimension: seconds_duration {
type: number
sql: ${TABLE}.seconds ;;
}
measure: total_seconds_duration {
label: "Total seconds Duration"
type: number
sql: ${seconds_duration} / cast(86400 as real);;
value_format: "[hh]:mm:ss"
}
}
```
Since the data needs to be displayed in a bar chart on the dashboard, if it is changed to manual calculation, it will become a string and the height on the bar chart is wrong.
So Can you please take a look or have a good solution?