Adding static data to widgets
Hey BeckyCrittenden
Another option would be to keep it super simple, and just write up a static data formula,
What I do in these scenarios;
1. Add a new measure in the chart you’re presenting the Revenue Values
2. Type in a static value for that month’s target; 300k, 350k..
3. Add it as a line chart, and add value labels
That’s it! KISS = Keep it simple and short 😉
You can then repeat that process for other static target values.If these target values are dynamic, and change in your data set for different months like you mention, you can maintain a target value XLS sheet and bring it into your data model as a target table. Then use the MAX/MIN values from there into this new target formula in your existing chart. That way the date filter will change the target value accordingly.
Another cool thing you can do is then apply simple conditional formatting to the actual revenue value measures, so you see which months are above or below target.If you have any other questions or if you’d like any help whatsoever in implementing my suggestion above, don’t hesitate to reach out.
P.S. we also have a freebie KPI card if you wanna go that way.We’re always here to help
Angelina from QBeeQ
QBeeQ - Gold Sisense Partner
[email protected]
Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news!Angelina_QBeeQ Thank you SO much, this is very helpful!
I hope you have a great day!
