I am trying to get a view of AVG consumption till date login I had in mind was totaling the license consumption followed by division with bays calculated via time difference between oldest timestamp vs now.
But ending up with the errors "The argument for "min" must be a Number or Number List, but a Date was given"
Custom Expression used:
sum(${ingestion_metrics.total_size_bytes_GiB})/ diff_days(min(${ingestion_metrics.timestamp_date}),now())
Hi @yadavmanjeet65,
How about utilising the measure 'Min Start Time (Ingestio Metrics Min Start Time)', and then using the below expression:
sum(${ingestion_metrics.total_size_bytes_GiB}) / diff_days(${ingestion_metrics.min_start_time}, now())
Kind Regards,
Ayman
Hi @yadavmanjeet65,
How about utilising the measure 'Min Start Time (Ingestio Metrics Min Start Time)', and then using the below expression:
sum(${ingestion_metrics.total_size_bytes_GiB}) / diff_days(${ingestion_metrics.min_start_time}, now())
Kind Regards,
Ayman
@AymanC The suggested expressions threw below error
<Field "ingestion_metrics.min_start_time" either does not exist in the current query or is a measure.>
@AymanC The suggested expressions threw below error
<Field "ingestion_metrics.min_start_time" either does not exist in the current query or is a measure.>
Hi @yadavmanjeet65,
Add the following field measure to your visualization.
Kind Regards,
Ayman
Hi @yadavmanjeet65,
Add the following field measure to your visualization.
Kind Regards,
Ayman
Thanks, AymanC..
It worked well.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.