I am using the Gauge to show my sales results.
But I want to show both a target point and compare it to last month.
Normally the line from previous month is the targetpoint but I want to adjust this.
Is this in any way possible? I also looked at the Comparative Fill Gauge but doesn't seem like the way to go.
Thanks in advance!
I've had success with the Filled Gauge chart type since there is a Target Value field you can use.
Thank you for your reply @MichelleH
I think you might have misunderstood me (or I did).
I attached an image of what I am trying to accomplish.
So although I have 48 sales compared to 54 last month my target is 45.
But with the normal gauge I cant compare to last month.
And with the period over period gauge I cant set a target point.
Hopefully it's more clear now 🙂
I see, you're looking for a month over month comparison with a target? You can try a Comparative Fill Gauge (Basic) chart like this:
This chart type doesn't seem to like aggregate Beast Mode calculations when I tried it, so it may require an ETL to summarize the data into a single line.