Forum Discussion
multi row card chart format
Hi,
I've a column called DurationConnected in seconds and I've converted via the query editor to hh:mm:ss in a new column called DurationConnected(min) like this: #time(0, 0, 0) + #duration(0, 0, 0, [DurationConnected]). This gives me what I want but the format is text (I know it's a common issue).
I only need this data in hh:mm:ss in a multi row card chart. Can I do this via a measure in the chart? Or does anyone have a tip here?
Thanks.
hi, Anonymous
After my test, you can do these as below:
Assume that we have this basic table
Step1:
use the formula like you to add a custom DurationConnected(min) column
#time(0, 0, 0) + #duration(0, 0, 0, [DurationConnected in seconds])
Step2:
Close&Apply
Step3:
select column DurationConnected(min) then click->Modeling->Data type->Time
Step4:
then select column DurationConnected(min) and click->Modeling->Format->Date Time->(HH:mm:ss)
Result:
Best Regards,
Lin
1 Reply
hi, Anonymous
After my test, you can do these as below:
Assume that we have this basic table
Step1:
use the formula like you to add a custom DurationConnected(min) column
#time(0, 0, 0) + #duration(0, 0, 0, [DurationConnected in seconds])
Step2:
Close&Apply
Step3:
select column DurationConnected(min) then click->Modeling->Data type->Time
Step4:
then select column DurationConnected(min) and click->Modeling->Format->Date Time->(HH:mm:ss)
Result:
Best Regards,
Lin