I have a dataset, which is the result of a join so the ID is not a unique key: +————+——————+——————-+—————| | — ID — | — Name — | — Gender — | — Role — | +————+——————+——————-+—————| | 001 | Alex B | Male | User | | 001 | Alex B | Male | Admin | | 002 | John C | Male | Agent | | 003 | Drew H | Female | User | | 003 | Drew H…
Is there a way to use fixed functions or something else to grab the first date that appears and the last date that appears? I am trying to calculate yearly attrition. I have it by month but adding up or avg the monthly % is not mathematically correct. I need to get the first month and last month's values within a certain…
I have a linked image of a video and the title of the video in one cell in my HTML table. How can I put space between my image and text in that single cell? I would like the text to just have a small space between it and the image. Here is my beast mode now: CONCAT('<div><a href="', Front End URL,'", "target="_blank"><img…
I have a client with a custom fiscal calendar. I have a report that automatically returns data from the previous fiscal week (Sunday to Saturday). I need a second report that will return the same data from two fiscal weeks ago. Does anyone know how I can automatically have the fiscal week updated for this report?
I'm working on a Sunburst Chart to show organizational hierarchy. I'm running into some issues where I've got 3 levels to my hierarchy and I'm only able show 1 of these without the visual disappearing. I've attached the sample data I'm working with and here is the setup on the card: Is this chart just not capable of…
You can see in area of the card below that I've highlighted, that the top value of this Legend vanishes when I interact with the card. Can I stop this behavior? Thanks
Hi, Am I missing something here? I have this card that compares last month % to this month %. However, It is not adding up correctly and I cant seem to figure out why. The 19% is the correct value for this month. Last month the value was 23%, I am not sure where 14% is coming from. If I switch it to a table view you can…
Hi folks, The legend on a link chart is including the rules set for the colours. How can this be removed to just show the label Thanks
We have a chart based on data that is updated daily, however it only updates if the value has changed. We want to see the flat line, i.e. if there has been no changed over time. I've tried changed the chart types and even change it to year to date, it displays nothing i.e. no data Any ideas?
It looks like you're new here. Sign in or register to get started.