Hi Everyone, I would like to show two different me...
# gooddata-platform
p
Hi Everyone, I would like to show two different metrics on a table, each of which should be filtered by a different date. Is this possible? To explain further, I have sales totals that should be displayed by the date of the sale, and refund totals that should be displayed by the date of the refund. As insights only let me select a single date, I can only show results either by refund date or order date. Can I create a metric that will force the results to use a particular date field so that I can use both dates in an insight?
m
Hi Paul, please see the following article which I hope will help in this case: Filter Facts and Metrics by Date with Different Date Dimensions https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/analytical-design[…]-data/filters-in-analytical-designer/filter-metrics-by-date/
p
Thank you Michael, this looks like it does exactly what I need. Thanks again