Hello,
I have a dimension_group called activity_date, a measure called counter and a table calculation where each counter value is offset by 7. Essentially, the data looks like this:
| activity_date | counter | counter_offset |
|---|---|---|
| 2020-03-01 | 100 | 10 |
| 2020-02-28 | 50 | 50 |
| 2020-02-27 | 30 | … |
| 2020-02-26 | 100 | … |
| 2020-02-25 | 200 | … |
| 2020-02-24 | 500 | … |
| 2020-02-23 | 100 | … |
| 2020-02-22 | 10 | … |
| 2020-02-21 | 50 | … |
| … | … | … |
When both counter and counter_offset are plotted as line graphs, the tooltip for both graphs obviously shows the activity_date. Is there a way to have counter_offset line graph tooltip to display a different date, which essentially is offset(activity_date, 7)?
Following the example, counter line graph’s tooltip would display 2020-03-01 (the x axis value) but counter_offset line graph’s tooltip would show the date 2020-02-22.