Dashboard Chart Widget Axis changes with each refresh

Kayla
Kayla ✭✭✭✭✭
in Formulas and Functions

The axis label on the dashboard chart widgets consistently changes with each refresh and will not maintain the order that it is in on the Report.

This is pulling from a summary report.

Occurring on a monthly report widget and quarterly.

I have a Support ticket in, but no good response. This is happening on multiple dashboards with various reports. I have changed the viewer mode, but that is not the answer.

Monthly Report - Dashboard Widget EX 1.png
Monthly Report - Dashboard Widget EX 2.png
Monthly Report - Dashboard Widget EX 3 - after refresh.png
Monthly Report - Dashboard Widget EX 4 - quarters.png


Tags:
· Share on FacebookShare on Twitter

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Kayla

    Thank you for reporting this unexpected behaviour. I'm able to reproduce this when group and summary are applied to the chart's source report.

    I've checked in with our Support team and they confirmed this is a known issue that we're actively working to resolve. I don't have an ETA for when a fix will be applied, but we're working on it!

    Cheers,

    Genevieve

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!