Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I have looked around different place and asked a couple of quesitons but can't seem to lock down if this is possible or not.
I have a visualisation which shows on a weekly basis the total number of hardware resources needed for our new artists starting.
Using 1 item as an example - Spec A96R (a workstation)
For the bar chart side of this there would be weekly bars to show the total needed for our onboarders.
17 May - 8
24 May - 6
31 May - 11
I also pull in our CMDB information and derive counts of our hardware (allocated / unallocated).
What I would like to show on the visualisation is a horizontal line that shows at the current point in time the unallocated count for the hardware.
In this example as of now there are 27 Spec A96R unallocated, so there would be vertical bars of the various weeks need for the machines and horizontal lines from the CMDB that shows the same hardware just as their unallocated total.
Is there a way to achieve this in a visualisation.
Thank you.
Solved! Go to Solution.
You can use MAX LINE OR MIN LINE from Visualization pane >> Analytics!
Hello, I just used Line and Cluster column chart from the Visualization pane.
yeh I tried that but the issue is the CMDB doesn't have a date as such. The measure I have just displays the total per Hardware Description that = unallocated. There is only ever 1 number per hardware item at any given time as it is a total.
Please provide more information related to columns and measures of your model.
This measure just calculates the total for the hardware items. I then filter it for 'Unallocated'
You can use MAX LINE OR MIN LINE from Visualization pane >> Analytics!
so do the bar chart based on the new starter information and use the max in the analytics from the measure?
Yes, try that way once!
@Anonymous , We need to know the dimension and measure for that .
Assume for item dimension fact allocation show allocation
then
sumx(values(Item[Item]), if(isblank(countrows(allocation)) , 1, blank())
Bascially converting blank means no record to 1 and record to null
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |