Home

Dashboard not showing actual value, but shows 1K - how can I change to actual value

%3CLINGO-SUB%20id%3D%22lingo-sub-643006%22%20slang%3D%22en-US%22%3EDashboard%20not%20showing%20actual%20value%2C%20but%20shows%201K%20-%20how%20can%20I%20change%20to%20actual%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-643006%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20the%20Number%20tile%3C%2FP%3E%3CP%3EWhen%20numbers%20are%20%26gt%3B1000%2C%20it%20will%20change%20to%201K%20-%26nbsp%3Binstead%20of%20actual%20value%201136.%3C%2FP%3E%3CP%3EHow%20can%20I%20change%20so%20it%20will%20so%20actual%20number%20-%20it%20is%20critical%20to%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-643006%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644172%22%20slang%3D%22en-US%22%3ERe%3A%20Dashboard%20not%20showing%20actual%20value%2C%20but%20shows%201K%20-%20how%20can%20I%20change%20to%20actual%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644172%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F162153%22%20target%3D%22_blank%22%3E%40Morten%20Waltorp%20Knudsen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20Azure%20Dashboards%2C%20I%20workaround%20this%20by%20changing%20the%20result%20to%20a%20text%20string%2C%20obviously%20at%20the%20final%20stage%20after%20any%20calculations%20are%20over.%26nbsp%3B%20e.g.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%7C%20project%20tostring(BilledGB)%20%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20250px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F115936i526939E4EBD2C4F7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Annotation%202019-05-24%20160050.jpg%22%20title%3D%22Annotation%202019-05-24%20160050.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644597%22%20slang%3D%22en-US%22%3ERe%3A%20Dashboard%20not%20showing%20actual%20value%2C%20but%20shows%201K%20-%20how%20can%20I%20change%20to%20actual%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644597%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20answer%2C%20but%20I%20just%20tested%20it%20-%20and%20none%20of%20the%20OVERVIEW%20TILES%20(Number%2C%20Two%20Number%2C%20Donut%2C%20etc)%20accepts%20a%20STRING%20value%2C%20only%20numbers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644633%22%20slang%3D%22en-US%22%3ERe%3A%20Dashboard%20not%20showing%20actual%20value%2C%20but%20shows%201K%20-%20how%20can%20I%20change%20to%20actual%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644633%22%20slang%3D%22en-US%22%3ESorry%2C%20I%20thought%20this%20was%20an%20Azure%20Dashboard%2C%20but%20I%20think%20your%20showing%20a%20View%20Designer%20tile.%20I'd%20suggest%20you%20look%20at%20Azure%20Dashboards%20or%20workbooks...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644697%22%20slang%3D%22en-US%22%3ERe%3A%20Dashboard%20not%20showing%20actual%20value%2C%20but%20shows%201K%20-%20how%20can%20I%20change%20to%20actual%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644697%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%26nbsp%3B%20Thanks%20again%20Clive.%20We%20are%20getting%20close%2C%20but%20Azure%20Dashboard%20is%20new%20to%20me.%20I%20ahve%20been%20using%20View%20Designer%20so%20far.%3C%2FP%3E%3CP%3EI%20have%20a%20simple%20query%20I%20would%20like%20to%20show%20on%20my%20dashboard%20with%20a%20single%20number.%3C%2FP%3E%3CP%3EWhen%20I%20Edit%20my%20dashboard%2C%20I%20have%20the%20option%20to%20add%2025%20tiles%20from%20the%20gallery%20dashboard.%20Which%20of%20them%20would%20give%20me%20either%20Single%20number%20or%20Two%20Numbers%20query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20simple%20Query%20could%20be%3A%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EHeartbeat%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Ewhere%3C%2FSPAN%3E%3CSPAN%3E%20TimeGenerated%20%26gt%3B%20ago(%3C%2FSPAN%3E%3CSPAN%3E31%3C%2FSPAN%3E%3CSPAN%3Ed)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20hint.strategy%3Dpartitioned%20arg_max(TimeGenerated%2C%20*)%20%3C%2FSPAN%3E%3CSPAN%3Eby%3C%2FSPAN%3E%3CSPAN%3E%20Computer%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Esummarize%3C%2FSPAN%3E%3CSPAN%3E%20total%3D%3C%2FSPAN%3E%3CSPAN%3Ecount%3C%2FSPAN%3E%3CSPAN%3E(Computer)%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Eproject%3C%2FSPAN%3E%3CSPAN%3E%20tostring(total)%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644725%22%20slang%3D%22en-US%22%3ERe%3A%20Dashboard%20not%20showing%20actual%20value%2C%20but%20shows%201K%20-%20how%20can%20I%20change%20to%20actual%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644725%22%20slang%3D%22en-US%22%3EEasiest%20way%20is%20to%20make%20sure%20you%20have%20first%20SHARED%20your%20dashboard%2C%20then%20from%20the%20query%20screen%20you%20can%20use%20the%20'pin%20to%20dashboard'%20option%2C%20You%20should%20open%20the%20dashboard%20in%20a%20separate%20tab%20or%20do%20a%20refresh%20to%20see%20the%20tile%20added%2C%20normally%20in%20the%20top%20right%20corner%20if%20there%20are%20multiple%20tiles.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644958%22%20slang%3D%22en-US%22%3ERe%3A%20Dashboard%20not%20showing%20actual%20value%2C%20but%20shows%201K%20-%20how%20can%20I%20change%20to%20actual%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You%20Clive.%20I%20have%20managed%20to%20solve%20it%20using%20Workbook%20in%20Azure%20Monitor%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3EThankx%20again%20!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Morten Waltorp Knudsen
Contributor

I'm using the Number tile

When numbers are >1000, it will change to 1K - instead of actual value 1136.

How can I change so it will so actual number - it is critical to me

6 Replies

@Morten Waltorp Knudsen 

 

For Azure Dashboards, I workaround this by changing the result to a text string, obviously at the final stage after any calculations are over.  e.g.

 

| project tostring(BilledGB) 

Annotation 2019-05-24 160050.jpg

@Clive Watson Thank you for your answer, but I just tested it - and none of the OVERVIEW TILES (Number, Two Number, Donut, etc) accepts a STRING value, only numbers

Sorry, I thought this was an Azure Dashboard, but I think your showing a View Designer tile. I'd suggest you look at Azure Dashboards or workbooks...

@Clive Watson  Thanks again Clive. We are getting close, but Azure Dashboard is new to me. I ahve been using View Designer so far.

I have a simple query I would like to show on my dashboard with a single number.

When I Edit my dashboard, I have the option to add 25 tiles from the gallery dashboard. Which of them would give me either Single number or Two Numbers query.

 

A simple Query could be:

Heartbeat
| where TimeGenerated > ago(31d)
| summarize hint.strategy=partitioned arg_max(TimeGenerated, *) by Computer
| summarize total=count(Computer)
| project tostring(total)
Easiest way is to make sure you have first SHARED your dashboard, then from the query screen you can use the 'pin to dashboard' option, You should open the dashboard in a separate tab or do a refresh to see the tile added, normally in the top right corner if there are multiple tiles.

@Clive Watson 

Thank You Clive. I have managed to solve it using Workbook in Azure Monitor :)

Thankx again !!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies