Hello team. Is it possible to create an MAQL metr...
# gd-beginners
a
Hello team. Is it possible to create an MAQL metric that shows a date attribute?
f
Hi Adair, depends on what you’re looking for! In GoodData Platform, it’s possible to use Date Attribute Arithmetics to calculate event durations, for example. You are also able to Find Min and Max Dates - meaning the earliest and latest dates some event occurred. Note that you may have to format the results so that they appear in a Date format, as the result will be displayed as an unformatted number, by default. The second article I posted explains how that can be achieved. If you’re looking to simply display dates with no calculation attached, you can simply add them to one of the Row or Column sections in the analytical designer - thus slicing your other metrics by them.
👏🏾 1
a
Well, I managed myself to turn a date attribute into a metric, but that only works if I put it in a table with some attribute column and I'd like to show it as a KPI on a dashboard. I'm obviously not an expert, but taking in consideration the GD documentation I'm afraid that's not possible.
f
Hi Adair, that really depends on what the metric calculates; Using a Headline insight, it’s definitely possible to display a date (see my screenshot), but it’s generally limited to MAX or MIN Date metrics - for example, showing the most recent transaction for a client. Then the dashboard filters would further refine it.
👍🏾 1