I have a 'WEEK' field in my data, which is used as a metric in several visualizations. However, the ISO WEEK format can be confusing as it doesn't clearly indicate the corresponding dates. For example, WEEK 42 corresponds to October 14, 2024, to October 20, 2024. I would like to display this date range as text while keeping the ISO WEEK format for the visualizations. How can I achieve this?
well this is not so straightforward, you have to create a calculated field as an extra dimension to have something like
CONCAT ( Start date - to - End date) and apply this in your chart,
Kind regards,
Krassi
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |