Forum Discussion

BeckyCrittenden's avatar
BeckyCrittenden
Cloud Apps
04-03-2025
Solved

Adding static data to widgets

Hi Sisense team! Is it possible to add static values to a widget that would allow creation of a visual? For example, in a dashboard showing Thisyear/Lastyear month over month revenue values, how mi...
  • Angelina_QBeeQ's avatar
    04-10-2025

    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!